Connect to 2 databases with 2 tables!!

Goldenlamp

Hey does some body knows how to make connections to, to databases and to tables!!! I know that it is easy to just put them together but it is importent that they are seperatet because arthor php!!:

I have the config.php how can I make a connection with this php code an still make a connection to another sql and table... ( 2 db and 2 tables )

Code:

<?php


$dbhost="localhost";  #SQL Database Hostname (Most is: localhost)
$dbusername="root";   #SQL Username
$dbpassword="";   #SQL Password
$dbname="news_sql"; #SQL Database Name





$connect = mysql_connect($dbhost, $dbusername, $dbpassword);

$db = mysql_select_db($dbname,$connect) or die ("Could not select database");
?>

laserlight

Why not have two tables in one database?

messels

you're trying to connect to two different tables within two different databases?

i'm not sure i see the problem...

did you just connect to the db's when you needed them? or just connect one after the other. i'm pretty sure connects don't persist through one another so if you connect to one you'll have to reconnect to the previously connected db when you need something from it. i could be wrong about that.

either way, there's no reason you can't just query the first db, set the variables to what you need and then run the next query, connection sequence using the variables from the first query.

so, roughly speaking,
mysql_connect (blha, blha, blah);
$query = "SELECT FROM db";
$var1 = $results["whatever you're getting"];
etc.
msql_connect(other, other, other);
$query2 = "SELECT FROM db WHERE x ='$var1'";
etc.
etc.

gl...

Goldenlamp

I'm gonna discribe it for you sir.

one of the database is username and the second database is company database.
And I need to get some table rows from both of the databases..

And the make a calcelation some $tax = round ((......

But I can't get the the connection right for both..

Hope that it did help a bit.

laserlight

Honestly, it is just a matter of:

$conn1 = mysql_connect(/* ... */);
$conn2 = mysql_connect(/* ... */);

Then you make sure to provide $conn1 or $conn2 to every function you use that belongs to the MySQL extension.

Goldenlamp

Thanks laserlight.. it did work... be 🆒

laserlight

Remember to mark this thread as resolved (if it is) using the thread tools.