Help? Design for Restaurant Descript with Comment and Rating
Posted: Wed Jul 30, 2003 1:44 pm
I'm about to try to make a site that lists all the local campus eateries around the school here. I want users to be able to leave a comment as well as a 1-5 rating.
I envision a main page
Clicking on a restaurant will display Restaurant Name and Averaged Rating some other info (delivery hours, phone, address, etc.) followed by user comments (with individual rating) and a form for comment and rating.Restaurant Name | Restaurant Phone | Rating
I realize I have to use multiple tables. But the set up is tricky. I probably need one table for the restaurant info, a second for the comments and a third for the ranking?Restaurant Name Rating
Restaruant Phone
Restaurant Address
Comments:
[comment1] [comment1rating]
[comment2] [comment2rating]
etc.
I was hoping to cheat by using a 5star ratings script i picked up and somehow combining it with a comment script from hotscripts.com but now I'm thinking it might be more efficient to go from scratch (borrowing from other scripts as needed). Any advice/pointers/ideas would be super super helpful.
Many thanks in advance.