help with making links in mysql and php

[Anon]

I have a recipe database written in php and mysql. I used a while loop to display all the current recipies in the database, but I want to view each individual by clicking a link that takes me to a dynamically created page with the recipe. How can I do this? Any help is appreciated! Thanks.

Wes

[Anon]

Here is what I would do. Create links like this <A HREF="viewrecipe.php?recipenum=$index">$index</A> in front of the name of each Recipe(put it in your while loop). In your while loop use a variable called $index that you increment each time the loop goes around, and start it at 0 or whatever your key starts at. I'm assuming you have a number as your primary key of your table. If you're not using a number then don't use $index, use whatever the primary key is.

Then in your script viewrecipe.php you query the database using the $recipenum. Where $recipenum is your primary key in your table.

[Anon]

here's what i have:

<?php

include("srd_connect.phtml");

$showname = mysql_query("select name from recipe");
$showrecipe = mysql_query("select * from recipe");

while ($row = mysql_fetch_array($showname)) {

echo ("<a href='$PHP_SELF?showrecipe=$showrecipe'>");
echo $row["name"];
echo ("</a>");

?>

still not working...i know there's a major part missing here. thx for your help.