Re: [PHP] Opening more than one database at a time?

D]>; <[EMAIL PROTECTED]> Sent: Sunday, January 20, 2002 8:51 PM Subject: Re: [PHP] Opening more than one database at a time? > Jeff, > > Can you let MySQL do the work for you, with INSERT ... SELECT? Here's the URL" > http://www.mysql.com/doc/I/N/INSERT_SELECT.htm

Re: [PHP] Opening more than one database at a time?

Jeff, Can you let MySQL do the work for you, with INSERT ... SELECT? Here's the URL" http://www.mysql.com/doc/I/N/INSERT_SELECT.html 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 p

Re: [PHP] Opening more than one database at a time?

It;'s entirely possible. Most database-related functions can take an optional link identifier parameter. You didn't use it, and in that case, database operations default to the last opened database connection. You can however do something like: $dblink1=mysql_connect($server1,$user1,$password1