I have a mySQL database. Version 5.0.
I have a table that is generated dynaically, this works fine.
In the table I have the following fields
RestName, Address, Phone, Price, Rating
This is the table where the webpage name lies for each restaurant.
tblRestaurants
RestID 1
RestName Red Place
RestPage Red_Place.php
I am storing a webpage in the RestPage field.
When I click on the RestName field in the table I want the webpage stored in the RestPAge field to come up. Needless to say I need a variable because you never know which restaurant will appear in the table.
I have this so far...
<td><a href='$row[$RestPage]$RestID=RestID'>$row[RestName]</a></td>
but it doesn't seem to be working. I'm new to this so..........I need some direction here. Thank you.