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

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

 



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@xxxxxxxxx] 
Sent: Wednesday, March 29, 2006 2:20 AM
To: php-general@xxxxxxxxxxxxx
Subject:  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


[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