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]

 




Chris wrote:
Paul Goepfert wrote:

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.


What do you get on both servers when you run it manually through phpmyadmin or some other tool?

Are they the same mysql version - select version(); ?

Same php version?

why not use the DATE_ADD function from mySQL??

(date,INTERVAL expr type)

eg:

mysql> SELECT DATE_ADD('1997-12-31 23:59:59',
    ->                 INTERVAL 1 DAY);

hope this helps!

Angelo

--
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