Search found 4 matches
- Sat Jan 03, 2009 9:41 pm
- Forum: PHP - Code
- Topic: Connect two databases at the same time, different servers
- Replies: 7
- Views: 353
Re: Connect two databases at the same time, different servers
Jcart,,,can u read english...i said there are no errors in the code....its just that I dont think php can connect to two databases on two different servers....i can translate for you in any language if you like
- Fri Dec 26, 2008 6:46 pm
- Forum: PHP - Code
- Topic: Connect two databases at the same time, different servers
- Replies: 7
- Views: 353
Re: Connect two databases at the same time, different servers
There are no error issues....the code works, it's just that it won't pull data from the 2nd DB (it says "Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource ")...my feeling is that you can't connect to 2 different DB that are on different servers at the sam...
- Fri Dec 26, 2008 6:35 pm
- Forum: PHP - Code
- Topic: Connect two databases at the same time, different servers
- Replies: 7
- Views: 353
Re: Connect two databases at the same time, different servers
Here is my code (I really appreciate you looking at this): //login to database1 $hostname_dw_db = "***"; $database_dw_db = "***"; $username_dw_db = "***"; $password_dw_db = "***"; $dw_db = mysql_pconnect($hostname_dw_db, $username_...
- Fri Dec 26, 2008 6:23 pm
- Forum: PHP - Code
- Topic: Connect two databases at the same time, different servers
- Replies: 7
- Views: 353
Connect two databases at the same time, different servers
I got a super tricky problem!!! In PHP, how can you have 2 active connections to 2 databases that are on 2 different servers at the same time inside a while loop????? I've tried this already: $db1 = mysql_pconnect($hostname1, $username1, $password1) or trigger_error(mysql_error(),E_USER_ERROR); mysq...