Comparing help

[dsbpac]

I have a db wiith the following fields

 

 

userid, postuserid, info

 

users post information as follows

 

userid 2  posteruserid 6  info blah blah blah

 

The postuserid is the id number of the person that is logged in and posting an article.

Userid is the users profile they are posting to.

 

I'm having an issue figuring out how to display [sOMETHING] only if the user logged in has not posted on that users profile. Any help is appreciated. Thank you

[Psycho]

I would assume you also have a users table, correct?

SELECT *

FROM users

WHERE userid NOT IN
(
    SELECT userid
    FROM posts
    WHERE postuserid = $loggedInUserID
)

EDIT: Moving to MySQL forum

Edited October 17, 2013 by Psycho