AND/ OR precedence mistake. Your query will return all the rows for which
Probably what you want is:
select * FROM OrderTable WHERE submitted=1 AND
dateinserted>='1036386000' AND dateinserted<='1036502796' AND
( order_status='Shipped' OR order_status='Not Shipped' )
Ignatius J. Reilly
----- Original Message -----
From: "Aaron Wolski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 2:59 PM
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!
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php