Trying to copy items to an archive DB.

[adriann]

In the basic & crude code example below,...

$result = mysql_query("select * from news, where status = "archived");
while($r=mysql_fetch_array($result)) {
// process $result as required
}
}

...it is my understanding that the variable "$result" holds 1 entire row of the content of a database. Firstly, is that statement correct.???

If so, I was wanting to transfer the entire row to an identically structured DB, for the purpose of arhival storage.

What would be an example of code that could transfer whole rows of info to an identically structured DB.

thx
Adrian

[ronverdonk]

As always with these sort of questions: before you ask: FIRST HAVE A LOOK AT THE STANDARD PHP documentation

http://nl2.php.net/manual/en/function.mysql-query.php

which clearly states:

[PHP]For SELECT, SHOW, DESCRIBE or EXPLAIN statements, mysql_query() returns a resource on success, or FALSE on error.
[/PHP]

Ronald :cool: