August 21st, 2000, 12:31 PM
Join Date: Aug 2000
Time spent in forums: < 1 sec
Reputation Power: 14
I don't do PHP, so here's an overview of how to do what you want to in generic terms:
When you build the table that displays the results, add a "Details" link. The idea is to manipulate the href of this link to include some GET parameters indicating which restaurant you're linking to. So, what you do, is make the href something like:
where you've populated $id with the id of the restaurant.
Then, in your script (myscript.php) you take the GET parameter and stick it into a SQL query that grabs the specific restaurant, e.g.:
(assuming you've put the id parameter into $id)
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
WHERE restaurant = '$id'
AND city = '$city';
or something along those lines. With that information you can then build a details page.
The concept is fairly simple -- you provide a more detailed context to your script to get more detailed information.
Hope that helps you out.