Re: PHP query on "date" field

Isn't date a reserved word that should not be used as a field name? It appeared that what was asked was if he should change the name of his field from date to date_1. It should definitely be changed if it is now called date. Jason Wong <phplist@gremlins.com.hk> said: > On Wednesday 31 October 2001 01:31 am, Jason wrote: > > > Here is my problem once again... =P I am wondering if I should change > > the date table to something other than date... maybe something like > > date_1? Would doing that resolve my issue, because of the fact that > > the date variable in php is function? Thanks in advance... > > What is the format of date as defined in your database? If date is of > type DATE or DATETIME then > > > $result = mysql_query ("SELECT * FROM ads > > WHERE fname LIKE '%$fname%' AND lname LIKE > > '%$lname%' AND phonea LIKE '%$phonea%' AND phone LIKE > > '%$phone%' AND > > date LIKE '%$date%'"); > > should be changed to: > > $result = mysql_query ("SELECT * FROM ads > WHERE fname LIKE '%$fname%' > AND lname LIKE '%$lname%' > AND phonea LIKE '%$phonea%' > AND phone LIKE '%$phone%' > AND date = '$date'" > ); > hth > -- > Jason Wong > Gremlins Associates > www.gremlins.com.hk > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > --