mysql error
Posted: Mon Sep 17, 2007 10:15 pm
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE prayer_date>='1189998899'' at line 1
code:
I can't seem to figure out what the problem is. =( maybe because of Where i have the WHERE at?
code:
Code: Select all
$time = 60 * 60 * 24;
$time = time() - $time;
$result = mysql_query("SELECT * FROM prayers ORDER BY priority ASC, prayer ASC WHERE prayer_date>='$time'") or die(mysql_error());I can't seem to figure out what the problem is. =( maybe because of Where i have the WHERE at?