Im really confused...

[Teen0724]

i run this query

$sql="SELECT * FROM news WHERE cat!='Admin Only' && private!='y' ORDER BY dateofpost LIMIT 7 "

I get no returns, i have records in my DB where both those conditions should be true. Whats wrong.

private is a CHAR(1) that can be null.

cat is a TINYTEXT that can not be null.

[cgraz]

well all you have there is a variable with text in it. Do you actually send this string to mysql so that it can execute it (using mysql_query()?)

You're also missing a semi-colon at the end of your line, although that causes a parse error, not a problem w/MySQL.

Cgraz

[Teen0724]

im not dumb, yes i execute it and yes it doesn't work. And i just posted the query from MySQL-Front, i double checked the results there.