Re: Date math functions...
| From: | 1LT John W. Holmes | Date: | Wed, 15 Jan 2003 16:25:51 +0000 |
| Subject: | Re: Date math functions... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24868@lists.php.net to get a copy of this message | ||
[snip]
> if ($dateDiff == 3) {
> mysql("$DBName","UPDATE Balances SET CompEarned=CompTaken+8 WHERE
> said='$said'") or die(mysql_error());
> mysql("$DBName","INSERT INTO Log VALUES('DATE_ADD($StopDate,
> INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')") or
> die(mysql_error());
>
> My big question is about using the "DATE_ADD" MySQL function inside
> the INSERT statement. Is this allowed? If it is allowed, is it a bad
idea
> for some reason? Is there a better way of doing this? Thanks in advance.
Sure, that's allowed. You have $StopDate in PHP, so you could do it with
some math in PHP, also, but then you'd have to worry about the end of
months, years, etc, whereas DATE_ADD will do this for you.
---John Holmes...