how many conditions are allowed to set after WHERE ?

[adwfun]

I made a Select.....Where... query with over 10 conditions after Where. It returned with a syntax error and I am wondering if there is a maximum conditions allowed.

I did that because I setup 5 dropdown menu to let user choose and then submit to get data, and there are 8 tables required in Select....

Please kindly advise.
Thanks ???

[btherl]

There's no limit (in theory), but huge queries can hit resource limits sometimes.  Can you post your query and the error message?

[ale1981]

Try putting the WHERE conditions inside (), like;

SELECT * FROM table WHERE (a=1, b=2, c=3, d=4)

[fenway]

You can place parentheses, to be sure, but you'll have to use AND / OR, not commas.