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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to