Re: Select where date is in period
| From: | boclair | Date: | Thu, 22 Mar 2001 13:26:42 +0000 |
| Subject: | Re: Select where date is in period | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7698@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: Steve Brett <SBrett@e-mis.com>
To: boclair <boclair@bigpond.net.au>; <php-db@lists.php.net>
Sent: Thursday, March 22, 2001 11:04 PM
Subject: RE: [PHP-DB] Select where date is in period
> i think i also used >= to indicate 'equal or greater to than'
instead of =>
> like you have ...
>
> Steve Brett
> Internal Development
> EMIS Ltd.
This seems to have been the problem. All I did for success was to
reorder the where conditions.
The created date variable and the field values for date_online and
date_offline were of the mySQL date type and single quoted.
Thanks
Tim Morris