I am trying to basically copy data from one database to another and am
wondering if it is possible to have more than one database open at a time.
So for example, I want to do something like this but am wondering if there
is a better way:
$dbcon = mysql_connect($db_server, $db_user, $db_passwd); //Make source
connection
mysql_select_db($db_name);
//Select source db
$source_result = mysql_query("SELECT * FROM users"); //Select all
info from users table
while ($row_cat = mysql_fetch_array($result)){
//Loop through and insert into new db
//Insert into new database
}
So where I have "Insert into new database" this is where I want to take some
of the information from the source and insert into the new database (which
uses a different user name and password as well).
Any help would be greatly appreciated :)
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
