Re: mysql_fecth_array() and function call as parameter
| From: | Jon Drukman | 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-