2 different database calls?

[sporkit]

im trying to mod my coppermite photo gallery and am having a little trouble. i managed to get the code that lets me put php code in my template.

the problem is when i try and call another database for my shoutbox i get an error like this....



and here is the code that im sticking in my template.

// Select the jokes database
    if (! @mysql_select_db("f8klan") ) {
      echo( "<p>Unable to locate the joke " .
            "database at this time.</p>" );
      exit();
    }
  
    // Request the text of all the jokes
    $result = @mysql_query("SELECT * FROM `shoutbox` ORDER BY `id` DESC  LIMIT 0 , 2 ");
    if (!$result) {
      echo("<p>Error performing query: " . mysql_error() . "</p>");
      exit();
    }
  
    // Display the text of each joke in a paragraph
    while ( $row = mysql_fetch_array($result) ) {
      echo("<p><b><em>" . $row["shoutdate"] . "</em></b><br> " . $row["shouttext"] . "<br> <b>" . $row["shoutname"] . "</b></p>");
    }
	

		 ?>

i also tried taking out this little bit of code out....

// Select the jokes database
    if (! @mysql_select_db("f8klan") ) {
      echo( "<p>Unable to locate the joke " .
            "database at this time.</p>" );
      exit();
    }

but am getting this error.

Error performing query: Table 'f8pics.shoutbox' doesn't exist

i know the problem is that i cant call 2 different databases at one time. does anybody know a way around this?

[website]

Well, connecting to 2 databases makes your code a bit more complicated. You could always move between databases on your connection or you could open up 2 connections (I don't know how efficiant that is though), then you would pass the link variable (the result from mysql_connect) around and use it when you do mysq_query etc. (then you would do mysql_query('query', $connectionToDatabaseA); etc.)

[sporkit]

then you would pass the link variable (the result from mysql_connect) around and use it when you do mysq_query etc. (then you would do mysql_query('query', $connectionToDatabaseA); etc.)

say whhhhhhhhat?

haha. that seemed a little strange to me. an example would proably help out. is there like a good guide or something out there that i could checkout?

[biggulp]

http://www.php.net/mysql_connect
http://www.php.net/mysql_query

basically you open 2 connetions instead of one but you must pass the link each time you use mysql_query()

e.g.

$connection = mysql_connect($host, $user, $pass);
$db = mysql_select_db($mydatabase, $connection);

$connection2 = mysql_connect($host, $user2, $pass2);
$db2 = mysql_select_db($mydatabase2, $connection2); 

[Icheb]

If both databases are on the same server with the same login information, just select the database instead of opening another connection for it. It's much faster.

[sporkit]

http://www.php.net/mysql_connect
http://www.php.net/mysql_query

basically you open 2 connetions instead of one but you must pass the link each time you use mysql_query()

e.g.

$connection = mysql_connect($host, $user, $pass);
$db = mysql_select_db($mydatabase, $connection);

$connection2 = mysql_connect($host, $user2, $pass2);
$db2 = mysql_select_db($mydatabase2, $connection2); 

thats awsome thanks alot. is calling 2 different databases like this slow?

[website]

It can be, yes.... depends on many factors such as how busy the server is, how good connection you have to the server etc.