RE: [PHP-DB] Idea as to why this query won't work as expected?
| From: | Josh Johnson | Date: | Tue, 05 Nov 2002 14:18:22 +0000 |
| Subject: | RE: [PHP-DB] Idea as to why this query won't work as expected? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22990@lists.php.net to get a copy of this message | ||
The or part should be in parens. Your bascialy saying grab everything
that has order_status='Shipped' and your date requirements, OR
everything where order_status is equal to 'Not Shipped'...
-- Josh
-----Original Message-----
From: Aaron Wolski [mailto:aaronjw@martekbiz.com]
Sent: Tuesday, November 05, 2002 9:00 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Idea as to why this query won't work as expected?
Hi All,
I have a query like:
select * FROM OrderTable WHERE submitted=1 AND
dateinserted>='1036386000' AND dateinserted<='1036502796' AND
order_status='Shipped' OR order_status='Not Shipped'
Now.. if I omit the "AND order_status='Shipped' OR order_status='Not
Shipped'" part the query works fine and only returns 2 results (as
expected). However, with the inclusion of the previous I get all the
results (currently 8) returned.
It seems to be ignoring everything before "AND order_status='Shipped' OR
order_status='Not Shipped'".
Any clues?
Much thanks!
Aaron