Re: PHP query on "date" field
| From: | Jason Wong | Date: | Wed, 31 Oct 2001 06:15:49 +0000 |
| Subject: | Re: PHP query on "date" field | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13878@lists.php.net to get a copy of this message | ||
On Wednesday 31 October 2001 05:11 am, Jason wrote:
> The date field is varchar. And I believe it is for daylight savings.
> I am trying out a couple of things on a test date field so I will get
> back with you guys after I try your suggestions. And by the way I
> sincerely appriciate all the help you and Rick are giving me. Thanks
> again,
In that case your original:
date like '%$date%'
should work as long as $date is formatted the same as what is stored in
the db.
Really, you should convert your date field into DATE or DATETIME then
you can use all the nifty date/time functions that MySQL provides!
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk