|
Posted by "Albert" on 01/10/06 15:39
Gregory Machin wrote:
> I have a table with a timestamp column and would like to use his to
> calculate the age of the record . how would i go about this...
Convert your timestamp to a unix timestamp (see mktime() function).
Use the value returned by time() to calculate the difference in seconds.
$age = time() - $tableTimestamp;
Divide by 3600 to get hours
> I would also like to exicute a mysql stament that pasess the tables and
> removes fields older than say 72 hours. how would i go about this . ?
Get a timestamp of 72 hours ago:
$olderThan72Hours = time() - (72 * 3600);
Convert to the same format as your timestamp column:
$timestamp = date('Y-m-d H:i:s', $olderThan72Hours);
Delete the records from the table:
mysql_query("DELETE FROM table WHERE timestamp >= '$timestamp'") or
die('Could not delete from table');
HTH
Albert
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.16/225 - Release Date: 2006/01/09
Navigation:
[Reply to this message]
|