Copy Table Data

[The_PHP_Newb]

Is there a quick way to transfer data from one table to another? I need to "archive" sales from a "current" table to an "archive" table. This could be anywhere from 1 entry to several hundred so you see why rewriting the data could be difficult. Each entry has 6-7 columns per entry.

Any help is appreciated. Thanks!

[TTT]

$q = "SELECT MAX(id) AS id FROM archive_table";
if(mysql_num_rows($q) != 0) {
   $maxid = mysql_result($q,0,0);
} else {
   $maxid = 0;
}
$q1 = "SELECT name FROM table1 WHERE id > $maxid ORDER BY id ASC";

while($row = mysql_fetch_row($q1)) {
   $q2 = "INSERT INTO archive_table (name) VALUES ('$row[1]')";

}
 

[The_PHP_Newb]

Thanks much, I assume I can add a WHERE in the first line?

I neglected to tell you I have to do chunks at a time (based on id). I only ask before trying because this is a live database.

EXAMPLE:
$q = "SELECT MAX(id) AS id FROM archive_table WHERE id = '$variable_here'";