Review system...

[ganeshcp]

Hi,
I am trying to build a move review system with PHP and MySQL
The obvious database field would be a id for the movie, rating field, the username (I have installed a php member script for logging in) and the review itself. But my question is....the table design..I mean how do I put all these fields....in one table itself? Sorry I am pretty new to SQL.

And aren't there any review scripts for free out there?!
Thanks

[Natty_Dreadlock]

I guess its not a bad idea at all to put all those fields into one table cause all that data belong together...
For free review scripts check e.g. hotscripts.com, they offer a lot of (mostly) free php-scripts, and I'm pretty sure that they have simple review systems, too. Or check out the code of popular tools like phpNuke, they sould have some code that might help u codin' your own script.

[daphreeek]

The way I'd do this is have these tables:

movies

mov_id
name
genre
date_released
........... (whatever else you want about the movie)

reviews

rev_id (unique for each review so easy to edit/delete)
mov_id (refers to mov_id above)
user_id (refers to user_id below for the person who wrote the review)
date (date written)
content

users

user_id
realname
username
password
dateofbirth
country
about
................. (whatever else)

Then use the users table for your login (or modify your existing one) so that when a review is displayed, you can get all the info on that user easily and when user details change, it only needs to be changed in one place. This makes things nice and easy 🙂

Then when you list the movies that have been reviewed, just do a select from movies query. When a movie is selected, do a select from reviews where mov_id=x

SIMPLE 🙂

Hope that helps
- Matt