[Jolten]

Thanks Tekton

Here's the run down. A user rates an item and when they rate this item, the item #, rating, and username are placed into the database.

What I need to to write an sql query that displays all items the user has not rated, therefore I need a query that basically states... table.userfield does not contain $bbuserinfo[username].

I can get table.userfield = '$bbuserinfo[username]' to display all the items a user has rated. What I'm having trouble with is getting items the user has NOT rated. using table.userfield != '$bbuserinfo[username]' results in all items showing and in fact all items showing twice for some reason. Including those items the user has rated.

I don't know if I can use if conditionals within an sql query and I'm not certain how to right the query if I can use conditionals.