Re: mysql_fecth_array() and function call as parameter

From: Date: Tue, 04 Apr 2006 05:49:49 +0000
Subject: Re: mysql_fecth_array() and function call as parameter
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-233186@lists.php.net to get a copy of this message
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-

« previous php.general (#233186) next »