Re: RES: [PHP] Mutiple SQL request
| From: | Ashley Sheridan | Date: | Wed, 04 Feb 2009 21:56:26 +0000 |
| Subject: | Re: RES: [PHP] Mutiple SQL request | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287647@lists.php.net to get a copy of this message | ||
On Thu, 2009-02-05 at 08:38 +1100, Chris wrote:
> Jônatas Zechim wrote:
> > For example i’ve this query:
> >
> >
> >
> > SELECT admin_nome FROM ctalk_admin WHERE admin_lastping <= '1233762658' AND
> > admin_lastping >= '1233762608' AND admin_id='1'
> >
> >
> >
> > I ran explain, the result for extra is ‘Impossible WHERE noticed after
> > reading const table...’
>
> Well this one is impossible.
>
> Find records with ping before '1233762658' AND
> find records with ping after '1233762608'
>
> The before time is before the after time.
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>
Erm, I don't think so, notice that 5 as the second to last digit. He
wants to find a ping before the larger number and after the smaller
number, which is perfectly valid in the normal rules of the universe I
know ;)
Ash
www.ashleysheridan.co.uk