I have tow queries on my website. A first query that extracts a number of records from my "Tutors" database based on the criteria "Location". This query works fine and returns "Id", "Name" and "HourlyRate".
I want my user to be able to see an extended profile for each record so I have for each record the following code:
$tmp = $row['Id'] ; echo "<td> <a href = \"tutor_profile.php?id=" .$tmp ."\"> See Profile </a></td>";
The code on my tutor_profile.php page is:
$id=$_GET['id']; $result = Mysql_query(" SELECT * FROM `Tutors` WHERE `Id` = '$id' "); echo "Name: ". $row['Name'];
But this second query returns nothing.
Any idea why? Thank for your help!