Linking to a record in mysql

[stary]

Hi all,

I'm working on a php form which displays all the records stored in mysql. When all the records are retrieved, a hyperlink is added to every records displayed...

My problem is that how am i able to create a link to another form whereby when user click on any hyperlink records, they are directed to another page with more specific details of the record which the user click? Please advise and thanks for any suggestions!

Cheers!

[Anon]

you need to post/get the id of the record in your link:

$tableid=$row('tableid');
print ("<A HREF='mynewform.php?id=$table_id'>link</A>");

then in your new form (mynewform.php), you need to use $id to generate the new data.

this assumes that reger globals is turned on of course.

[stary]

Hi Craig,

Thanks for your advice... but i'm stil very blur in retrieving the $tableid so .. juz wondering .. whether u can explain further for the retrieval of of $tableid?? A section of my code is shown below:

while( $row = mysql_fetch_array(SELECT * FROM tablename))
{
echo "<a href=\"mynewform.php\">$row[0] </a>\n";
echo "<a href=\"mynewform.php\">$row[2]</a>\n";
echo "<a href=\"mynewform.php\">$row[3]</a>\n";
}

All records will be displayed and how am i going to capture the $tableid in the the initial form before posting ??

Thanks again in advance!
Cheers!