Hi there, This worked perfectly for me! Thanks for the tip - I shall remember this :) To all who replied - thanks for your help as well. Regards, Aaron > -----Original Message----- > From: Ignatius Reilly [mailto:ignatius.reilly@free.fr] > Sent: Tuesday, November 05, 2002 9:15 AM > To: aaronjw@martekbiz.com; php-db@lists.php.net > Subject: Re: Idea as to why this query won't work as > expected? > > > 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' ) > > HTH > Ignatius J. Reilly > ____________________________________________ > ----- Original Message ----- > From: "Aaron Wolski" <aaronjw@martekbiz.com> > To: <php-db@lists.php.net> > Sent: Tuesday, November 05, 2002 2:59 PM > Subject: 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 > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
