Nightmare WHERE

[Anon]

Hi

I am trying to do a multiple WHERE query on a MySQL table. The different sections of the where clause are constructed from a seach form and a series of switch statements.

If I write my statement using PHP logic it would look like this:

SELECT * FROM table1 WHERE ((field1>0 AND field1<101) OR (field2>0 AND field2<101)) AND type=3

This obviously doesn't work and neither do any of the many other formats I've tried.

Can anyone see how to format this query?

[[deleted]]

That statement look perfectly ok to me.
What did SQL say about it?

[Anon]

mmm...

Big sorry all round - 'twas my connection, not my SQL!!

what a dumbass... thanks anyway!