[PHP] Re: mysql_fecth_array() and function call as parameter

2006-04-03 Thread Jon Drukman
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 FRO

RE: [PHP] Re: mysql_fecth_array() and function call as parameter

2006-04-03 Thread Chrome
neral@lists.php.net Subject: Re: [PHP] Re: mysql_fecth_array() and function call as parameter Paul, Try TO_DAYS(curdate()) instead - if not you can't say we didn't try! ;-) If that doesn't work you may want to try a MySQL list. - Joe On 4/3/06, Paul Goepfert <[EMAIL PROTECTED]> wrote:

Re: [PHP] Re: mysql_fecth_array() and function call as parameter

2006-04-03 Thread Joe Wollard
Paul, Try TO_DAYS(curdate()) instead - if not you can't say we didn't try! ;-) If that doesn't work you may want to try a MySQL list. - Joe On 4/3/06, Paul Goepfert <[EMAIL PROTECTED]> wrote: > > I included the or die function on the end of my query statement. When > I tested this on my web

[PHP] Re: mysql_fecth_array() and function call as parameter

2006-04-03 Thread Paul Goepfert
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 = da

[PHP] Re: mysql_fecth_array() and function call as parameter

2006-04-03 Thread Jon Drukman
Paul Goepfert wrote: function determineDay () { $return = ""; $query1 = mysql_query("SELECT months FROM Month WHERE m_id = month(curdate())"); $query2 = mysql_query("SELECT dayNum FROM Days WHERE dayNum = day(curdate())"); $