Re: [PHP-DB] PHP query on "date" field From: Bruno Gimenes Pereti (pereti <email protected>)
Date: 10/30/01

What I use to do is to print the sql and try it in the command line to know
it I'm constructing it correctly.

$sql = "select foo from bar...";
print "$sql<br>\n"; ## add this line

execute your script and copy the line to the mysql command line. If the
result is what you expect it should be working.

{Hope this helps} else {tell us}.

Bruno Gimenes Pereti.

----- Original Message -----
From: "Big Nickel" <signup <email protected>>
To: "Bruno Gimenes Pereti" <pereti <email protected>>
Sent: Tuesday, October 30, 2001 4:02 PM
Subject: Re: [PHP-DB] PHP query on "date" field

> I apologize... there really isn't any error messages.. it just shows that
> there are no results to be displayed but when i telnet into the db there
are
> plenty of dates that met my search criteria. I just need to know why it
wont
> display the results... and I am thinking that because in php the date
> function is the same thing i am using for a variable... not sure if that
is
> the problem but i am open to suggestions on it. Thanks again. 

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