vchris Posted November 7, 2007 Share Posted November 7, 2007 How can I connect to 2 databases? I've been looking around and didn't find anything useful... Link to comment Share on other sites More sharing options...
Ingolme Posted November 7, 2007 Share Posted November 7, 2007 Well, you just have to declare the connection for each database. Here's an example:$con1 = mysql_connect("server1","user1","password1");$con2 = mysql_connect("server2","user2","password2");When using functions like mysql_query() don't forget to put $con1 or $con2 as the connection parameter. For example:$data1 = mysql_query("SELECT * FROM table",$con1);$data2 = mysql_query("SELECT * FROM anothertable",$con2); Link to comment Share on other sites More sharing options...
vchris Posted November 7, 2007 Author Share Posted November 7, 2007 Works great, thank you very much! Link to comment Share on other sites More sharing options...
SpOrTsDuDe.Reese Posted November 7, 2007 Share Posted November 7, 2007 That was pretty basic..I came into here and was like "Great Ill see what I can do ." You trashed my dreams -.- Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.