WHERE and ORDER BY

[Infame]

Hello guys!

"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";

Is there any reason as to why this block is not working? What is the rule for formating such queries?

Thanks.

[Infame]

Hello guys!

"SELECT * FROM $tableName WHERE cata != 'abc' AND ORDER BY times desc LIMIT $start, $limit";

Is there any reason as to why this block is not working? What is the rule for formatting such queries?

Thanks.

Edit: Should inform that I want to retrieve all the items of a database, 'cept for those who has 'abc' in their cata(catagory) item. Then order it after date.

All that work, 'cept for the "Where cata != 'abc'" implementation.

[pritaeas]

$sql = "SELECT * FROM $tableName WHERE cata <> 'abc' ORDER BY times DESC LIMIT $start, $limit";