This is probably gonna sound strange or it might prove to be intresting.
At the moment if I want to move a row from one table to another I do this.
SELECT ENTIRE NEWS ROW FROM DATABASE
INSERT ROW INTO THE ARCHIVE TABLE
DELETE OLD ROW FROM NEWS TABLE
This however is quite cubersome, as I have to call the MYSQL_Query(); command 3 times...which I can guess there must be another way... Is there a Move Command in SQL that I can use to re-locate a row from one table to the next.
Just haven't got a clue where to start can anyone point me in the right direction.
Heres some of the code although its not finished coz I thought of this idea, and decided to come here b4 I go any further.
//---------------- START OF CODE---------
// Copy The Original Row
$sql = "SELECT * FROM News WHERE ID='$id'";
$result = MYSQL_QUERY($sql);
// Insert to New Location
$sql = "INSERT INTO NewsArchive blah blah blah";
MYSQL_QUERY($sql);
// Delete The Original
$sql = "DELETE FROM News WHERE ID='$id'";
MYSQL_QUERY($sql);
//-----------------------------------------
Thanks to all those who have helped.
Sorry to be a burden with this question.
-regards-
UniMatrix
