This worked perfectly for me!
Thanks for the tip - I shall remember this :)
To all who replied - thanks for your help as well.
> -----Original Message-----
> From: Ignatius Reilly [mailto:ignatius.reilly@;free.fr]
> Sent: Tuesday, November 05, 2002 9:15 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Idea as to why this query won't work as
> AND/ OR precedence mistake. Your query will return all the
> rows for which order_status='Not Shipped'
> 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
> > 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
> > OR order_status='Not Shipped'".
> > Any clues?
> > Much thanks!
> > Aaron
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php