hi all, i am a really nOOb at mysql but i was wondering if you could tell me if this code makes sence.
PHP Code:
// join query
$query = "SELECT users.id, user_photos.id, rating FROM 'users', 'user_photos', 'rating'
WHERE rating = (users.id AND user_photos.id";
$query=mysql_query($query) or die(mysql_error());
what i am trying to do is make a simple number rating system. I wont to join the id in USERS table with the id in USER_PHOTOS.
I have made a RATING table with both id's and rating fields (not sure if that was correct)
if anyone can please show me how this would be done or if you know any sites that could help |
