Neverside

2 MySQL Connections

I haven't tried this yet but can you be connected to 2 different mySQL servers at the same time?

___________________

<sig here>

I don't see a point in this.

___________________

Originally posted by blackmesa:

Okay! thats the last time i search up goatse on google

There is a point... I need to take the information from one DB and update the other DB with it and yes i know i can jus open one connection store the info in a variable and then connect to the other DB but i wanted to see if i could do it while im connected to 2 DB's at the same time....

___________________

<sig here>

sure, why not. open up a new connection with a diff name($link2) for the 2nd database. http://us2.php.net/mysql_connect

and do mysql_query($query, $link2);

___________________

-Developer
-Forum Leader
-NeverNET

yeah, as aonic said, just specify links everywhere. Easier with a DB class.

___________________

http://www.philbrodeur.com - Expert PHP Development and Tutorials