Is this possible?

tribe

Hi everyone, I’m not sure if this can be done or not, I think so, but not really sure where to start. I’ll try and simplify this so that everyone understands the situation.

Let’s say I have a database that is currently updated by a user that submits data via a web page interface. We’ll call it “news.” What the news person wants to do is make it so that she can set a date for the news to expire, or rather, move to an archive.

Is there a function that would take the news and move it to an archive?

Is there a way to do this using dates?

I’m not really sure where to begin.

Thanks in advance,

Tribe

kidsleep

You could use a function to "move" the news to an archive when you use the web interface to add more news based on date.

i.e. move old news to the archive if date is greater than a month old.

I would write some example code but I'm at work right now. Maybe when I get home...

tribe

So there's a function to move data based on dates?

I would assume that I just need to write something that uses a

< or > sign. So, if "news item date > archive date --> move to archive.

I'm just not sure where to begin.

coditoergosum

Try something along the lines of this:


$cid = mysql_connect($host,$usr,$pwd); 
if (!$cid) { echo("ERROR: " . mysql_error() . "\n");    } 

$todays_date = mktime();
$month_ago = $todays_date - 2592000; // subtract 30 days
$SQL = " SELECT * FROM news "; 
$SQL = $SQL . " WHERE date < '$todays_date' ";

$retid = mysql_db_query($db, $SQL, $cid); 

if (!$retid) { echo( mysql_error()); } 
else { 
while ($row = mysql_fetch_array($retid)) {  

$id = $row["id"]; 
$other_field1 = $row["other_field1"]; // Grab all info in the row
$other_field2 = $row["other_field2"]; 

// Move to archive table
$SQL = " INSERT INTO archive "; 
$SQL = $SQL . " (other_field1, other_field2) VALUES "; 
$SQL = SQL . " ('$other_field1', '$other_field2') "; 
$move_to_archive = mysql_db_query($db, $SQL, $cid); 

// Delete from news table
$SQL = " DELETE FROM news WHERE id = $id"; 
$delete_from_news = mysql_db_query($db, $SQL, $cid);

There might be errors in that, I wrote it quickly on the fly. But the idea is, select everything in the database that is a month old, then insert it into an archive table, and delete it from the news table.