Help With Query

[limitphp]

I get all comments for a song with this:

SELECT songCommentID, username,date,comment 
FROM songcomments 
WHERE songID = '$songID' 
ORDER BY date ASC

 

As its pulling each comment from the songcomments table, I need it to check another table to see if the user has reported that particular comment.

The table it will check will be report_comments.  I'm guessing I will need to have an inner join? to report_comments and check to see if the userID and songCommentID match up.  If they do, then the user has already reported it. 

 

thanks for any help....my brain is a little confused right now.....

[ohdang888]

proabbaly something like this is what you are looking for:

SELECT * FROM songcomments, report_comments 
WHERE songcomments.songID = '$songId' AND songcomments.songCommentId = report_comments.userID

[Ken2k7]

SELECT s.*
FROM songcomments s
INNER JOIN report_comments r
     ON s.songID = r.userID
WHERE s.songID = '$songID'
ORDER BY s.date