RE: [PHP-DB] Idea as to why this query won't work as expected?
| From: | Aaron Wolski | Date: | Tue, 05 Nov 2002 14:12:43 +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-22991@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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: [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
> >
>