Database Query Error.

[Anon]

Hello

I have the following statement and I get the following error: Database Query Error.

Can anyone tell me why?

mysql_connect($server, $db_user, $db_pass);

$today=date("Y-m-d",mktime(microtime()));

$result=mysql_db_query($database, "select * FROM prayer where pdate='$today'");

[Anon]

maybe
$today=date("Y-m-d",time());
would work

-paul
http://xhawk.net