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

Reply via email to