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