Re: [PHP-DB] PHP query on "date" field From: biorn <email protected>
Date: 10/30/01

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

-- 

-- 
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>