time

[xlordt]

if i wanted to delete a record of the db that has 2 hours passed right how would i do it.. for example

my db field is holding the current sime stamp from 2 hours ago how would i calculate this using the time function in my if sumbtion

i tried doing

$expire = time-120;

 if($row['f_start_time'] == $expire)
 {
   echo "Expired";
   exit;
 }else{
   echo "dammn";
 }

but its not working.. any hints?

[weekender]

assuming the field f_start_time is of type TIMESTAMP

first, you need to fetch the row with the UNIX_TIMESTAMP mysql function, as mysql timestamps are a different format to unix timestamps as used by php

$sql = "SELECT *, UNIX_TIMESTAMP(f_start_time) AS f_start_time WHERE 1";

then you calculate the timestamp of two hours ago. You were close with the time - 120 bit, but a timestamp is seconds not minutes

$then = time();
$then = $then - 7200; //7200 is the number of seconds in two hours

you now have the timestamp of exactly two hours ago. To delete all records from greater than two hours ago...

$sql = "DELETE FROM table WHERE UNIX_TIMESTAMP(f_start_date) < '$then'";

this is all from the top of my head so may need a little tweak - but i think it'll work as is

adam

[xlordt]

what if i wanted to do that for like 32 hours from now.. do i do the same in seconds? or is there a shorter day?

[weekender]

you can use [man]strtotime()[/man] to calculate your timestamp

$then = strtotime("32 hours ago");

strtotime takes a natural language query and applies it to a timestamp (or now, if no timestamp given)

[cahva]

If you have that f_start_time as datetimefield you could simply use mysql's own date functions to delete the rows:

$sql = "DELETE FROM table WHERE f_start_date < NOW() - INTERVAL 32 HOUR";