RE: [PHP] Not sure if this is a php problem or a mysql problem

If you want to do it in PHP you can always do : $Tomorrow = date( "Y-m-d", strtotime ("1 day" ) ) ; Or more general : http://www.weberdev.com/get_example-292.html Sincerely berber Visit the Weber Sites Today, To see where PHP might take you tomorrow. SEO Data Monitor http://seo.weberdev.com -----Original Message----- From: Paul Goepfert [mailto:paul.goepfert@gmail.com] Sent: Wednesday, March 29, 2006 2:20 AM To: php-general@lists.php.net Subject: [PHP] Not sure if this is a php problem or a mysql problem 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