Re: RES: Mutiple SQL request

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux