SQL query.. need to do the equivalent of this in PHP

[bsewell]

Hi,
I have a table and I need to write a SQL to limit the resulset set based on 2 conditions, by IP and out of that resultset, remove the rows which have nothing in 2 columns.

So I have tried this but it's not producing the expected results:
SELECT * FROM stats WHERE ip LIKE '%192.168.0.1%' OR ip LIKE '%192.168.1.2%' AND 'topic'!='' AND 'cat"!=''

But I'm still drawing some rows where both topic and cat columns are blank.

Does anyone have ideas?

Cheers,

[pritaeas]

Replace != with <>

[smantscheff]

You need brackets around your OR clause and no apostrophes around column names:

SELECT * FROM stats WHERE 
  (ip LIKE '%192.168.0.1%' OR ip LIKE '%192.168.1.2%')
  AND topic!='' AND cat!=''