druagord — Wed, 17 Sep 2003 14:18:31 +0000

i think that when you specify the field you need VALUES like this

<?php
if ($arc == "ok"){
mysql_query("INSERT INTO listarchive (name,company,phone,extension,email) VALUES (
SELECT name,company,phone,extension,email FROM list WHERE ID=$ID)");
} 
?>

or if those are all the fields you have in the table use

<?php
if ($arc == "ok"){
mysql_query("INSERT INTO listarchive 
SELECT * FROM list WHERE ID=$ID");
} 
?>