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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]