Not sure if this is a php problem or a mysql problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

I have developed a php functilon that is to return the date +1 from a
Mysql database.  My sql statement is as follows

SELECT dayNum FROM Days Where dayNum >= day(curdate())+1;

The function works great on the intended webserver but when placed on
a different mysql server (The one I have using to develop the webpage)
the return variable with the intended SQL statement is not being set. 
I Think it has something to do with thlis "day(curdate())" portion of
my sql statement.  When I had "month" in place of "day" I was able to
ge a output.  I don't have a problem with "year(curdate())" or
"month(curdate())".  Even though the functilon works on the final
destination webserver I would like to know why it won't work on my
testing server.

Thanks

Paul

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux