Date Increment

[Scrumpers]

I pull in a date from a html form in the format dd-mm-yyyy I then convert it to yyyy-mm-dd ready for writing to mysql but before I do this I would like to increment it by one day.

Can anyone help me with this as its brought in as text from the html form and then just using + 1 on it I seem to just get
2002-10-10 + 1 when I print to see what mysql is going to receive.

[GBahle]

could you please post your code? That would make it easier finding the error.

[intenz]

Try...

$strDate = 'dd-mm-yyyy';
$arrDate = explode('-',$strDate);
$intDay = $arrDate[0] + 1;
# $intDay is then your variable with the incremented day.

[enterume]

you can use mysql DATE_ADD() fucntion in your inserting/updating sql statement, for example:

INSERT INTO Table(id,date) values ('1', INTERVAL 1 DAY + $InputDate);

I try with my select statement liek :

SELECT INTERVAL 1 DAY + "1997-12-31";

But never try with update/insert statement.

[Scrumpers]

//Open Database and write to second table
$Link = mysql_connect ($Host, $User, $Password);
$NumNights = $Array["NumNight"];
while ($NumNights > 0) {
$NumNights--;
$Query = "INSERT into $TableName2 values ('$Array[ArrivDate]'+ $NumNights, 2,7,1)";

//Print success if write successfull or not and close db
if (mysql_db_query ($DBName, $Query, $Link)) { }
else {
print ("The query could not be executed!<BR>\n");
}
}
print ("Query $Query exeuted!<BR>\n");
mysql_close ($Link);