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);