How do I do this with one query, tried a few things and cant get it to work ... SELECT * FROM `table` WHERE ( `cat1` = '1' OR `cat2` = '1' OR `cat3` = '1' OR `cat1` = '9' OR `cat2` = '9' OR `cat3` = '9' ) ORDER BY `id` DESC LIMIT 30 , 30 Code (markup): I know its something to do with the WHERE clause.
Are you getting a mysql error or a php error? Or are you just not getting back what you think you should?