Re: RES: [PHP] Mutiple SQL request
| From: | Chris | Date: | Wed, 04 Feb 2009 21:38:08 +0000 |
| Subject: | Re: RES: [PHP] Mutiple SQL request | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-287646@lists.php.net to get a copy of this message | ||
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/