Re: [PHP-DB] PHP query on "date" field From: Jason Wong (phplist <email protected>)
Date: 10/30/01

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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>