Hi
I am trying to add an archiving feature to a php/MySQL site... Basically, what I need to do is once they have viewed an entry, they can click on archive and it will be copied to a new (archive)table and then deleted from the old one....
I delete part is easy but for some reason the copy part is not working right... Am I doing something wrong?.... I am using the following code:
---------------------------------------
<?php
if ($arc == "ok"){
mysql_query("INSERT INTO listarchive (name,company,phone,extension,email)
SELECT name,company,phone,extension,email FROM list WHERE ID=$ID");
}
?>#($ID is provided by the link)
--------------------------------------
If anyone knows of another way of doing this, please let me know.
Thanks for your help,
Mizzy
druagord posted this at 14:18 — 17th September 2003.
He has: 335 posts
Joined: May 2003
i think that when you specify the field you need VALUES like this
<?phpif ($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
<?phpif ($arc == "ok"){
mysql_query("INSERT INTO listarchive
SELECT * FROM list WHERE ID=$ID");
}
?>
IF , ELSE , WHILE isn't that what life is all about