problem again :((

[jonsof]

i tried this sql syntax

SELECT c.categoryid, c.category FROM user_category u, categories c WHERE u.userid='$row[userid]' AND c.categoryid <> u.categoryid

I want to see all the categories that each categoryid is not in user_category table.

where is my fault?

[DigitalExpl0it]

use DISTINCT

[tomhath]

Should be something like this:

SELECT c.categoryid, c.category
FROM categories c
LEFT JOIN user_category u
ON c.categoryid = u.categoryid
AND u.userid='$row[userid]'
WHERE u.categoryid is null

Here's the full explanation:

http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html

[jonsof]

Thank you tomhath you saved my life 🙂 it worked very very welll!

Thanks again!