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:[EMAIL PROTECTED]
Sent: Wednesday, March 29, 2006 2:20 AM
To: [email protected]
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
