Search found 4 matches

by flywheel
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
by flywheel
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...
by flywheel
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_...
by flywheel
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...