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

From: Date: Wed, 29 Mar 2006 00:20:13 +0000
Subject: Not sure if this is a php problem or a mysql problem
Groups: php.general 
Request: Send a blank email to php-general+get-232786@lists.php.net to get a copy of this message
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

« previous php.general (#232786) next »