Autofill premade form.

[Lehuizen]

Hi

Hope someone can help me, I have a database that contain records like name , age etc. This data displays in a premade profile page. The profile page is linked to from a page that displays a short description with a image that is also populated from the database.

I only want to have one profile page, and that page needs to be populated when the image link is clicked on the description page. Example, you click on short description (displaying some of row 3 info, from database for example)page link, profile page opens, and populates fields with row 3s data.

I have the code to display the data on the description page and the profile page. I dont have allot of know how with coding, my code at the moment was done trough Dreamweaver Cs3.

That code is working fine and displaying the data in the fields created for them.

 

 

I would realy appreciate some guidance.

[inversesoft123]

No one here will code for you but we will try to help you correcting your code. paste here if you tried any.

[Lehuizen]

Code from the description page, Im specifiying wich row to display =2

What I need help with is, what to do if record =2 is displaying on the description page, and you click the link I want the profile page to be populated with row=2 data. If =3 on the description page is clicked, then the profile page needs to be populated with row=3 data automatically.

So if you can guide me, I will apreciate it. I have no clue on what code to use,

 

mysql_select_db($database_details, $details);
$query_name = "SELECT FST_NAME FROM DETAILS WHERE DETAILS.ID=2";
$name = mysql_query($query_name, $details) or die(mysql_error());
$row_name = mysql_fetch_assoc($name);
$totalRows_name = mysql_num_rows($name);

mysql_select_db($database_details, $details);
$query_Age = "SELECT AGE FROM DETAILS WHERE DETAILS.ID=2";
$Age = mysql_query($query_Age, $details) or die(mysql_error());
$row_Age = mysql_fetch_assoc($Age);
$totalRows_Age = mysql_num_rows($Age);

mysql_select_db($database_details, $details);
$query_Area = "SELECT AREA FROM DETAILS WHERE DETAILS.ID=2 ";
$Area = mysql_query($query_Area, $details) or die(mysql_error());
$row_Area = mysql_fetch_assoc($Area);
$totalRows_Area = mysql_num_rows($Area);

mysql_select_db($database_details, $details);
$query_Image1 = "SELECT DETAILS.IMAGE_1 FROM DETAILS WHERE DETAILS.ID=2 ";
$Image1 = mysql_query($query_Image1, $edetails) or die(mysql_error());
$row_Image1 = mysql_fetch_assoc($Image1);
$totalRows_Image1 = mysql_num_rows($Image1);

 

Current code from the profile page, I dont want to specify here what data to display, I want it to autofill with the data that correspond with the link from the description page.

 

mysql_select_db($database_details, $details);
$query_Area = "SELECT AREA FROM DETAILSWHERE DETAILS.ID=2";
$Area = mysql_query($query_Area, $details) or die(mysql_error());
$row_Area = mysql_fetch_assoc($Area);
$totalRows_Area = mysql_num_rows($Area);

mysql_select_db($database_details, $details);
$query_Nationality = "SELECT NATIONALITY FROM DETAILS WHERE DETAILS.ID=2";
$Nationality = mysql_query($query_Nationality, $details) or die(mysql_error());
$row_Nationality = mysql_fetch_assoc($Nationality);
$totalRows_Nationality = mysql_num_rows($Nationality);

mysql_select_db($database_details, $details);
$query_Languages = "SELECT LANGUAGES FROM DETAILS WHERE DETAILS.ID=2";
$Languages = mysql_query($query_Languages, $details) or die(mysql_error());
$row_Languages = mysql_fetch_assoc($Languages);
$totalRows_Languages = mysql_num_rows($Languages);

mysql_select_db($database_details, $details);
$query_Age = "SELECT AGE FROM DETAILS WHERE DETAILS.ID=2";
$Age = mysql_query($query_Age, $details) or die(mysql_error());
$row_Age = mysql_fetch_assoc($Age);
$totalRows_Age = mysql_num_rows($Age);

mysql_select_db($database_details, $details);
$query_STATISTICS = "SELECT STATISTICS FROM DETAILS WHERE DETAILS.ID=2";
$STATISTICS = mysql_query($query_STATISTICS, $details) or die(mysql_error());
$row_STATISTICS = mysql_fetch_assoc($STATISTICS);
$totalRows_STATISTICS = mysql_num_rows($STATISTICS);

mysql_select_db($database_details, $details);
$query_Height = "SELECT HEIGHT FROM DETAILS WHERE DETAILS.ID=2";
$Height = mysql_query($query_Height, $details) or die(mysql_error());
$row_Height = mysql_fetch_assoc($Height);
$totalRows_Height = mysql_num_rows($Height);

mysql_select_db($database_details, $details);
$query_Weight = "SELECT WEIGHT FROM DETAILS WHERE DETAILS.ID=2";
$Weight = mysql_query($query_Weight, $details) or die(mysql_error());
$row_Weight = mysql_fetch_assoc($Weight);
$totalRows_Weight = mysql_num_rows($Weight);

mysql_select_db($database_details, $details);
$query_Haircolour = "SELECT HAIR_COLOUR FROM DETAILS WHERE DETAILS.ID=2";
$Haircolour = mysql_query($query_Haircolour, $details) or die(mysql_error());
$row_Haircolour = mysql_fetch_assoc($Haircolour);
$totalRows_Haircolour = mysql_num_rows($Haircolour);

mysql_select_db($database_details, $details);
$query_Eyecolour = "SELECT EYE_COLOUR FROM DETAILS WHERE DETAILS.ID=2";
$Eyecolour = mysql_query($query_Eyecolour, $details) or die(mysql_error());
$row_Eyecolour = mysql_fetch_assoc($Eyecolour);
$totalRows_Eyecolour = mysql_num_rows($Eyecolour);

mysql_select_db($database_details, $details);
$query_Interests = "SELECT INTEREST FROM DETAILSWHERE DETAILS.ID=2";
$Interests = mysql_query($query_Interests, $details) or die(mysql_error());
$row_Interests = mysql_fetch_assoc($Interests);
$totalRows_Interests = mysql_num_rows($Interests);

mysql_select_db($database_details, $details);
$query_Biography = "SELECT BIOGRAPHY FROM DETAILS WHERE DETAILS.ID=2";
$Biography = mysql_query($query_Biography, $details) or die(mysql_error());
$row_Biography = mysql_fetch_assoc($Biography);
$totalRows_Biography = mysql_num_rows($Biography);

mysql_select_db($database_details, $details);
$query_Ratesincall = "SELECT IN_CALL FROM DETAILS WHERE DETAILS.ID=2";
$Ratesincall = mysql_query($query_Ratesincall, $details) or die(mysql_error());
$row_Ratesincall = mysql_fetch_assoc($Ratesincall);
$totalRows_Ratesincall = mysql_num_rows($Ratesincall);

mysql_select_db($database_details, $details);
$query_Ratesoutcall = "SELECT OUTCALL FROM DETAILS WHERE DETAILS.ID=2";
$Ratesoutcall = mysql_query($query_Ratesoutcall, $details) or die(mysql_error());
$row_Ratesoutcall = mysql_fetch_assoc($Ratesoutcall);
$totalRows_Ratesoutcall = mysql_num_rows($Ratesoutcall);

mysql_select_db($database_details, $details);
$query_Travelcost = "SELECT TRAVEL_COST FROM DETAILS WHERE DETAILS.ID=2";
$Travelcost = mysql_query($query_Travelcost, $details) or die(mysql_error());
$row_Travelcost = mysql_fetch_assoc($Travelcost);
$totalRows_Travelcost = mysql_num_rows($Travelcost);

mysql_select_db($database_details, $details);
$query_Wishlist = "SELECT WISH_LIST FROM DETAILSWHERE DETAILS.ID=2";
$Wishlist = mysql_query($query_Wishlist, $escorts) or die(mysql_error());
$row_Wishlist = mysql_fetch_assoc($Wishlist);
$totalRows_Wishlist = mysql_num_rows($Wishlist);

mysql_select_db($database_details, $details);
$query_Arrangingapointment = "SELECT APPOINTMENT FROM DETAILS WHERE DETAILS.ID=2";
$Arrangingapointment = mysql_query($query_Arrangingapointment, $details) or die(mysql_error());
$row_Arrangingapointment = mysql_fetch_assoc($Arrangingapointment);
$totalRows_Arrangingapointment = mysql_num_rows($Arrangingapointment);

mysql_select_db($database_details, $details);
$query_Name = "SELECT FST_NAME FROM DETAILS WHERE DETAILS.ID=2";
$Name = mysql_query($query_Name, $escorts) or die(mysql_error());
$row_Name = mysql_fetch_assoc($Name);
$totalRows_Name = mysql_num_rows($Name);