adding 24 hours to current time and saving it to mysql database

[kranks]

Hello all,

I'm trying to add 24 hours to the current time and save it in a mysql database.

The datatype of the column im saving the information to is 'timestamp'.

I think the problem might be that im not sending the information in the correct format to the column.

I gave this a try but it just results in the a blank page on loading

<?
$timestamp = timestamp() ;
$timestamp1 = $timestamp + 24 * 60 * 60;
?>

<?
(database connection)...

$sql="INSERT INTO proposal (tomorrowtime)
VALUES
('$timestamp1')";

?>

Just wondering if anybody could suggest where im going wrong?

Any help would be greatly appreciated

many thanks

[dagon]

kranks;10925935 wrote:

Just wondering if anybody could suggest where im going wrong?

there is no php function called timestamp()

[kranks]

Thanks for pointing that out Dagon.

Sorry i'm just learning php.

I was meant to use the time () funtion!

<?
$time1 = time() + 24 * 60 * 60;
?>

<?
(database connection)...

$sql="INSERT INTO proposal (tomorrowtime)
VALUES
('$time1)";

?>

Just wondering if anyone could suggest how i go about converting the value stored in $time1 into a value that would be compatible with a timestamp column in mysql database?

[dagon]

$sql="INSERT INTO proposal (tomorrowtime)
VALUES
(NOW()+ INTERVAL 1 DAY)";

for more mysql time and date functions see: 11.6. Date and Time Functions

[kranks]

cheers for your help dagon,

that works fine!