move data from table to another table

[vietboy505]

I want to move the row from OLD TABLE to NEW TABLE where:
the OLD TABLE, status == 'S' & the dateModify is over a week, move that row (all data to the NEW TABLE).
Then delete that row on the OLD TABLE.
I try the code below, nothing happen, no data is output. I try to change to +1 day, it's still same but it should display the data a day old.

How can I fix that?

<?php include("config.php"); ?> 
<?php
//INFO from mySQL 
//id INT NOT NULL AUTO_INCREMENT, 
//PRIMARY KEY(id), 
//name VARCHAR(30), 
//status VARCHAR(1), 
//dateModify TIMESTAMP,  

$overWeek=date('Y-m-d H:i:s', strtotime('+1 week'));
$statusCheck="S"; 
mysql_select_db($dbnameNAME) or die(mysql_error()); 

 $result = mysql_query("INSERT INTO $tableNEW 
        (name, status, dateModify) 
        SELECT name,status,dateModify FROM $tableOLD WHERE status = '$statusCheck' AND dateModify >= '$overWeek' " ) 
    or die($errCon . mysql_error());  

?>

<?php

mysql_select_db($dbnameNAME) or die(mysql_error());
$result2 = mysql_query("SELECT * FROM $tableNEW ")
or die(mysql_error());

while($row2 = mysql_fetch_array($result2)) {

echo $row2['name'];
echo $row2['status'];
echo $row2['dateModify'];

}

//free up memory
mysql_free_result($result2);
?>

[devinemke]

<?php
// connect to db here

$result = mysql_query("SELECT * FROM $tableOLD WHERE status = 'S' AND dateModify < DATE_SUB(CURDATE(), INTERVAL 1 WEEK)") or exit(mysql_error());
if (mysql_num_rows($result))
{
	while ($row = mysql_fetch_assoc($result))
	{
		$sql = "INSERT INTO $tableNEW SET 
		name = '" . $row['name'] . "',
		status = '" . $row['status'] . "',
		dateModify = '" . $row['dateModify'] . "'";

	mysql_query($sql) or exit(mysql_error());

	echo 'row ' . $row['id'] . ' successfully inserted into ' . $tableNEW . '<br>';
	$old_ids[] = $row['id'];	
}

mysql_query('DELETE FROM ' . $tableOLD . ' WHERE id IN(' . implode(',', $old_ids) . ')') or exit(mysql_error());
}
else
{
	echo 'no rows found in ' . $tableOLD . ' matching your search criteria';
}
?>