Do a Two Table Query

[casbboy]

I have one table with my users (titled 'Users') and I have another table with their comments (titled 'Comments').

Each User has a column for RANK, and I want this current rank to be shown next to the users' comments.

Like:

User 1 (4)
User 5 (2)

And so on.

How can I setup a mysql query that goes through the rows of comments ('Comments' table) but also grabs the user rank for each comment from the 'Users' table as well.

'user_id' is the primary in the 'Users' table and is also a key in the 'Comments' table as well.

Thanks
Ryan

[stewartship]

Try the following (this is presuming that comments in the comments table is labelled as comments if not change accordingly:

$query = "SELECT Users.user_id, Users.rank, Comments.comment FROM Users, Comments WHERE Users.user_id = Comments.user_id"

[casbboy]

here is what worked:

$gcomments = mysql_query("SELECT users.user_id, users.username, users.platform, users.comments, users.rank_id, users.rank, comments.comment_id, comments.person_id, comments.user_id, comments.comment, comments.date FROM comments JOIN users ON (comments.user_id = users.user_id) WHERE person_id='$personid' ORDER BY comment_id DESC",$connection);

Thanks
Ryan

[stewartship]

good stuff! (: