SELECT coursereview.ID, coursereview.courseid, coursereview.review, coursereview.image, coursereview.userid, coursereview.name, course.city, course.state, phpbb_users.username
FROM coursereview, course, phpbb_users
WHERE coursereview.id <= 4
AND (coursereview.courseid = course.id)
This query isn't working for what I want, I need to get 4 rows of data
I need most of the data from coursereview but I need the name and location from course where the coursereview courseid equals the course id along with the username from phpbb_users based on a userID in course review.
I am pretty sure I would have to do some joining here but I haven't the foggiest where to begin.
Sorry edited the missing comma but taht's not it
