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
//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 :)


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]

Reply via email to