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
> plenty of dates that met my search criteria. I just need to know why it
> 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
> 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]

Reply via email to