Hello:
I'm having a little problem with an image rating script I'm writing.
I've divided my script into THREE tables in MySQL using MyISAM
Images
image_id
imagename
rating_amount
ave_rating
Users
user_id
user_name
user_pass
UserRating
user_id
image_id
image_rating
Basically I'm trying to display ALL the images in the Images table and IF, the user rated that particular image, show their rating.
I just can't figure out if I should build one QUERY or if I should do two seperate queries, one to pull out all the images and another to pull out the user ratings.
What do you recommend?
