Connecting to multiple MySQL DB in PHP

Hey, I'm working on a new project which will involve constant switching between two DB's. The only way I can do that at the moment is to keep reopening each one as I need it, so I've tried to use the following script to keep both open all the time, but it isn't working.

PHP:

$dbhypo = mysql_connect('127.0.0.1', 'root');
mysql_select_db('hypostasis', $dbhypo);
$dbdraw = mysql_connect('127.0.0.1', 'root'); 
mysql_select_db('draw', $dbdraw);
$result = mysql_query("SELECT * FROM gigs ORDER BY id DESC",$dbhypo);
while ($row = mysql_fetch_object($result)) {
echo $row->venue;
}
$result = mysql_query("SELECT * FROM gigs ORDER BY id DESC",$dbdraw);
while ($row = mysql_fetch_object($result)) {
echo $row->venue;
}


Both $dbhypo and $dbdraw seem be accessing the draw database. Please help!

 

Sorry if I wasted anyones time, but I sorted the problem out myself, for some reason it just started working when I used a different user to connect to each time.

 

having the same user connect to each probably caused a loop error? I've just started messing with this stuff myself :\

 

I think it was because you cant use the same user twice for opening different DBs at the same time. Somthing like that. Very confuddling.