Working out time

[graham23s]

Hi Guys,

 

say i have a time in mysql: 2008-09-01 13:27:31

 

how would i work out in PHO 24 hours later? what i want to do is if a customer adds something into there shopping cart and dont buy within 24 hours i run a query to delete!

 

thanks guys

 

Graham

[thebadbad]

strtotime()

 

<?php
$time = '2008-09-01 13:27:31';
$next = date('Y-m-d H:i:s', strtotime("$time + 24 hours"));
?>

[graham23s]

Thanks mate!

 

does this look ok?

 

<?php
// Auto delete the users cart 24 hours after making selection
$q_times = "SELECT `date` FROM `fcp_orders`";
$r_times = mysql_query($q_times);
$a_times = mysql_fetch_array($r_times);
   $times = $a_times['date'];
   
$time = $times;
$next = date('Y-m-d H:i:s', strtotime("$time + 24 hours"));

// delete query
$q_delete = mysql_query("DELETE FROM `fcp_orders` WHERE `date` => $next");
?>

 

id test it but i need to wait 24 hours lol

 

cheers

 

Graham

[thebadbad]

No problem. I'm not sure you can compare the date fields with =>, but I could be wrong. If you can't, I'm sure there's a command for comparing dates in MySQL. Else calculate the timestamps in the query, and compare those.

 

Also, shouldn't you surround $next with single quotes, inside the query?