Better explanation...

[gdgilbert]

Sorry if my descriptions aren't clear!

I want visitors to query based on cuisine, restaurant name, delivery or catering. So, if they chose "pizza" as the cuisine from a drop-down box, I would like them to be shown the entire list of restaurants that offer pizza, then I would like each listing to be a hyperlink to that restaurant's page.

I know this is probably something very simple, so I appreciate your patience!

Greg

[bernouli]

well, try this

if ($id) { 

   $result = mysql_query("SELECT * FROM restaurants WHERE rest_id=$id",$db); 
   while($myrow = mysql_fetch_array($result)) { 
      printf("Restaurant ID: %s\n<br>", $myrow["rest_id"]); 
      printf("Restaurant Name: %s\n<br>", $myrow["rest_name"]); 
      printf("Cuisine Code: %s\n<br>", $myrow["rest_cuisine"]); 
      printf("Delivery?: %s\n<br>", $myrow["rest_delivery"]); 
      printf("Catering?: %s\n<br>", $myrow["rest_catering"]); 
      printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", "restaurantpage.php", $myrow["rest_id"], $myrow["rest_name"], $myrow["rest_cuisine"]); 
   }

}

[gdgilbert]

That's exactly what I needed! Thank you very much. I appreciate your time and patience!

Greg