RE: [PHP-DB] MySql and PHP question

2005-04-10 Thread Jeffrey D. Means
: [PHP-DB] MySql and PHP question All, I have a question as how I can return some results that I am looking for. Ideally I'd like to run this sql statement but for some reason MySql won't allow me to run it: SELECT * FROM zip_code WHERE zg_latitude between ((select zg_latitude from

RE: [PHP-DB] MySql and PHP question

2005-04-07 Thread Juffermans, Jos
-Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: 07 April 2005 06:04 To: PHP Subject: [PHP-DB] MySql and PHP question All, I have a question as how I can return some results that I am looking for. Ideally I'd like to run this sql statement but for some reason MySql won't allow

Re: [PHP-DB] MySql and PHP question

2005-04-07 Thread graeme
: ReClMaples [mailto:[EMAIL PROTECTED] Sent: 07 April 2005 06:04 To: PHP Subject: [PHP-DB] MySql and PHP question All, I have a question as how I can return some results that I am looking for. Ideally I'd like to run this sql statement but for some reason MySql won't allow me to run it: SELECT * FROM

Re: [PHP-DB] MySql and PHP question

2005-04-07 Thread Bastien Koert
subselects are available as of 4.1 bastien From: graeme [EMAIL PROTECTED] To: Juffermans, Jos [EMAIL PROTECTED] CC: 'php-db@lists.php.net' php-db@lists.php.net Subject: Re: [PHP-DB] MySql and PHP question Date: Thu, 07 Apr 2005 12:55:13 +0600 From memory earlier versions of MySQL don't support

[PHP-DB] MySql and PHP question

2005-04-06 Thread ReClMaples
All, I have a question as how I can return some results that I am looking for. Ideally I'd like to run this sql statement but for some reason MySql won't allow me to run it: SELECT * FROM zip_code WHERE zg_latitude between ((select zg_latitude from zip_code where zg_zipcode =