[SOLVED] Too many WHERE, ANDs in Query?

[bsamson]

Is it possible to have too many WHERE, AND statements in one query?

 

Example:

SELECT * FROM v2followups WHERE store='11' AND (DATE_FORMAT(FROM_UNIXTIME(`day15`), '%Y/%m/%d') = '2008/05/16' AND day15status != 'c') OR (DATE_FORMAT(FROM_UNIXTIME(`day45`), '%Y/%m/%d') = '2008/05/16' AND day45status != 'c') OR (DATE_FORMAT(FROM_UNIXTIME(`day90`), '%Y/%m/%d') = '2008/05/16' AND day90status != 'c') AND cbtype='f'

(The above query was ran in phpMyAdmin)

 

All seems to work EXCEPT it also returns entries where cbtype='c'. Any suggestions as to why this isn't working?

 

Thanks in advance!

[p2grace]

 

Try this:

 

<?php
SELECT * FROM v2followups WHERE store='11' AND ((DATE_FORMAT(FROM_UNIXTIME(`day15`), '%Y/%m/%d') = '2008/05/16' AND day15status != 'c') OR (DATE_FORMAT(FROM_UNIXTIME(`day45`), '%Y/%m/%d') = '2008/05/16' AND day45status != 'c') OR (DATE_FORMAT(FROM_UNIXTIME(`day90`), '%Y/%m/%d') = '2008/05/16' AND day90status != 'c')) AND cbtype='f'
?>

[bsamson]

Thanks p2grace!!!!