MySQL Connection Problem

Nuke Soldier Joined: Aug 13, 2003 Posts: 13

Is it possible for a block to connect to another database on MySQL considering the connection information is correct?

Posted: Fri Oct 17, 2003 2:39 pm

I thought to myself "I might need to do that one day". So I spent the last half hour or so figuring it out. Yes it is possible. I tested it by adding the following code to the bottom of the whosonline block.

Code:

$dbthis = @mysql_connect("localhost", "username", "password");
if (!$dbthis)
{
$content .="Connected to host";
}
else
{$content .="Connected to host";}
if (! @mysql_select_db("2nd database name",$dbthis))
{
$content .=" Not connected to database";
}
else {$content .="Connected to database";}
mysql_close();
include "config.php";
require_once ("mainfile.php");
$db = new sql_db($dbhost, $dbuname, $dbpass, $dbname, false);
if(!$db->db_connect_id) {
message_die(CRITICAL_ERROR, "Could not connect to the database");
}

Seems you have to close the 2nd dbase connection and reconnect back to the nuke dbase or everything else stops working......thats what lines from mysql_close do. Try it out substituting your own passwords etc.

Nuke Soldier Joined: Aug 13, 2003 Posts: 13

Scratch that - I got it to work - w000000t

Very Happy

Edit:
Forgot this forum doesn't do "This post was editted x times"

I literally had my code layed out with like 5 questions. I appreciate your help. Your post worked for me. Smile

Ever need anything cruise over to the site listed in my sig Smile