Autofill premade form, from a link.

[Lehuizen]

I hope someone can help me, I have no coding experience. This coding was done with Dreamweaver.
I have one Database, a Description page and a Profile page. The Description page has profiles listed, the info displayed there comes from the database. Once you go to the Profile page from the specific record on the Description page it shows all the fields in a premade format on the page from the database.
Is there something you can do, that will only use one profile page, and auto populate the profile page when the, for example row=2 or =3 is selected to automaticly populate the profile page ia a link from the description page.

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);
Report to moderator    41.132.159.76

 

[stricken]

you gonna have to lay that code out properly for someone to help.

 

[Raithlin]

Google Results - there are plenty of articles / forum answers to this. I suggest you take some time to learn exactly what you posted, and you will soon know how to do what you want.

 

[Nod]

At the start of you form page, you look for the "id" param.

if ($id) {
//do stuff
}

This is where you will check if "id" is specified, and then do the sql part, and assign the tables values to variables that you will use in the form.

After that, you will have change your form to include something like:

Contact Number :<input type=text name="ContactNumber" <?php if($contactnumber); then echo "value=\"$contactnumber\"";?> />

If no "id" param is supplied, you will have only an empty form, ready to be filled in. If you want the field to be unmodifiable, you could add "readonly" to the php code above.

I haven't coded in a while, so please excuse if I missed something.