How to run a search in DB, then put values into hyperlinks

[jjmusicpro]

Hello everyone i am new here!

 

I was wondering how i can run a DB query then stick the results in hyperinks, so when they click a hyperlink it will take then to say an update page.

 

I have 1 table called test_table with 3 rows ID, First_Name and Last_Name

 

thanks again!

[HuggieBear]

Something like this should work...

 

<?php
// Set query
$sql = "SELECT * FROM test_table";

// Execute it
$result = mysql_query($sql);

// Loop through the results
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
   // Echo them out
   echo "<a href='update.php?id=" . $row['id'] . "'>" . $row['First_Name'] . " " . $row['Last_Name'] . "</a><br>\n";
}
?>

 

Regards

Huggie