[SOLVED] Removing Old Data

[monkeypaw201]

So, I have a database and I would like to "flush" it every 15 minutes and remove any data older than 15 minutes.

 

The code I am using right now removes everything even If its just a few minutes old. The column `last_update` is formatted using time()

 

<?php
#Connect to database
$con = mysql_connect("localhost","user","pass");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }

#Select database
mysql_select_db("database", $con);

#Declare Flush Timestamp
$timestamp = time();

#Cycle Through and remove excess flights
$flush = mysql_query("SELECT * FROM `active_flights`");
while($row_flush = mysql_fetch_array($flush))
{

#Generate Timeout Timestamp
$timeflush = $row_flush['last_update'] + 900;

if($timeflush > $timestamp)
{

	mysql_query("DELETE FROM `active_flights` WHERE `id` = '$row_flush[id]' LIMIT 1");

	mysql_query("DELETE FROM `active_flights_archive` WHERE `archive_id` = '$row_flush[archive_id]'");

}

}

 

Any suggestions?

[adam84]

Couldn't you use a cron job to run that script every 15 minutes?

[monkeypaw201]

Couldn't you use a cron job to run that script every 15 minutes?

 

Yes, It is a cron job... but the problem is that right now when it runs, it deletes EVERYTHING, not just old data..

[monkeypaw201]

bump 

[revraz]

Eliminate the middleman and only SELECT the rows that fall into that criteria instead of reading all of them in and then checking.