Can you let MySQL do the work for you, with INSERT ... SELECT? Here's the URL"

HTH - Miles Thompson

At 06:20 PM 1/20/2002 -0500, Jeff Lewis wrote:
>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 (
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP General Mailing List (
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