[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
[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
]
Subject: Re: [PHP-DB] Date math functions...
[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
W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:32 AM
To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Date math functions...
[snip]
if ($dateDiff == 3) {
mysql($DBName,UPDATE Balances SET CompEarned=CompTaken+8 WHERE
said
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.
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());
Actually this is generating another error. Now, without