Separate hyperlinks

Anon

I am new to php and need a little help here.

I have a web site using a MySql dB with recipes and I am trying to design a search result page that will help narrow down a visitors choices.

There might be 50 different types of cakes listed and if someone doesn't know

what the title or name of a particular recipe is, I want them to be able to pull up a table showing ALL the cakes, then click on one name, which will pull up the complete recipe for that item.

I can create a search page that will pull up just the cakes, and place them in a table, plus display the title or name of each recipe, and their id number, but how do I include a separate hyperlink for each recipe, so they can click on the name of a recipe and have it display all the ingredients for just that particular recipe?

Thanks in advance
Frank

Anon

Make a link to the Cake name similar to this:

I assume your first page is using a query to generate your drop down list of cakes? If it is take a variable (ID or similar) and use it to make a hyperlink to RecipeShow.php. Now set up this page with your ingredients table and presto there you have it in a nutshell.

Anon

Hi,
Thanks for the input, but for some reason I just couldn't get it to work. Like I said, I am real new at this.

Maybe this will help. Here is the code one of my forms is sent to. Where and how would I place the exact hyperlink?

if ($type == "")
{$type = '%';}

if ($title == "")
{$title = '%';}

$result = mysql_query ("SELECT * FROM recipe1
WHERE type LIKE '$type%'
AND title LIKE '$title%'
");

if ($row = mysql_fetch_array($result)) {

do {
printf("Type of Recipe: %s\n ", $row["type"]);

print (" ");
printf("Title of Recipe: %s\n ", $row["title"]);

print ("");
printf("First Name: %s\n ", $row["first"]);
printf("Last Name: %s\n ", $row["last"]);

} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}

Thanks
Frank