Re: Date math functions...
| From: | Jason Wong | Date: | Wed, 15 Jan 2003 17:19:28 +0000 |
| Subject: | Re: Date math functions... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24879@lists.php.net to get a copy of this message | ||
On Thursday 16 January 2003 00:55, NIPP, SCOTT V (SBCSI) wrote:
> Actually this is generating another error. Now, without the single
> quotes I am getting the following error:
>
> Column 'StartDate' cannot be null
>
> It looks like for some reason the DATE_ADD is returning a NULL
> value. Any more ideas?
Which probably means your $StopDate is 0. What does it actually contain? You
really should assign your query to some variable ($query) THEN plug it into
your query function. If and you have any problems you can echo $query to see
what you're passing to mysql.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
I'm having BEAUTIFUL THOUGHTS about the INSIPID WIVES of smug and
wealthy CORPORATE LAWYERS ...
*/