Not sure if this is a php problem or a mysql problem
| From: | Paul Goepfert | 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