connect to two databases

brauchi

I think I am doing soemthing wrong with my code but i don't know what this could be. I have two databases which are called article and advertiser. In one page I transfer data from the article database and i can print them out with the echo command. And the values are showing up on the screen.

Here is now the problem I am having. I would like to filter advertiser which have the same ad_category value. As the advertiser information is stored in the advertiser database I am doing the following:

$dbcnx=@mysql_connect('localhost','root','password');
mysql_select_db('bonjourparis.advertiser');

$ads = @("select ad from advertiser where ad_category = '$ad_category_new'");

echo($ads);

I took ad_category_new with me from the previous page. But it seems as if it doesn't work once I connected to the new database?

Thank you in advance

andrea

archangel_617b

Originally posted by brauchi

$dbcnx=@mysql_connect('localhost','root','password');
mysql_select_db('bonjourparis.advertiser');

$ads = @mysql_query("select ad from advertiser where ad_category = '$ad_category_new'");

echo($ads);

[/B]

First note: Use [ code ] or [ php ] tags when posting code. Makes it a lot easier to read.

As to your problem, you should be passing $dbcnx to the [man]mysql_select_db/man and [man]mysql_query/man functions. I have not tested using two databases at once myself (usualy one would put all you data in separate tables within the same database), but providing the db connection to the mysql functions should do the trick.

brauchi

thank you for your fast answer. can you explain what you mean with "providing the db connection to the mysql functions"?

I guess I wasn't very clear. I have only one "real database" and I have some tables in it (articles, advertiser....)

archangel_617b

$dbcnx is the connection to the database and you pass it to functions like [man]mysql_query/man by doing

mysql_query($sql, $dbcnx);

That was all I meant there.

If it's a single database, you should not be connecting to the specific tables. There is no need since you specify the table in the FROM clause in your SQL. Eg. FROM advertiser is all you need to do to select the table you want to use.