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 <[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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 



-- 




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

Reply via email to