connect to the db
select the records
iterate through the result set
printing out links to your detail script
with the record IDs passed in the urls
The following is only slightly adjusted from the manual's example:
<?php
mysql_connect($host, $user, $password);
mysql_select_db("bookdatabase");
$result = mysql_query("select book_id, book_title from booktable");
while ($row = mysql_fetch_array($result)) {
echo "<a href=\"bookdetail.php?book_id=";
echo $row["book_id"];
echo "\">";
echo $row["book_title"]."</a><br>\n";
}
?>
This presumes you have written, or will write, a script named bookdetail.php that will display the full book record as a page.
