Paul Goepfert wrote:
I included the or die function on the end of my query statement. When I tested this on my web page I got the following error Query2 Failed: You have an error in your SQL syntax near '(curdate())' at line 1 When this code executed: $query2 = mysql_query("SELECT dayNum FROM Days WHERE dayNum = day(curdate())") ; I can't see where the error is. Can anyone see the error?
that query works fine here. what version mysql are you using? (server, not client).
-jsd- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php