2dbs 1 script..

[joey3002]

i really need some help, im stuck with something that i imagine is simple.

i have php script that has for each queries, inside the 1 query, i want to run this:
$query = "INSERT INTO msgid (n_date) values('2006-12-14')";
mysql_query($query,$db3);

now, the entire script runs off of db2, however, this query, runs off of a 2ndary db.

any help with this would be hugely appreciated.

thanks

[joey3002]

anyone? please..

this might make it easier to help..

connect to db1
run query
for each command {
run query #2 on db2
}

i have it running the query, however, its only getting the 1st item, since when it connects to the db2, it must stop the db1 connection so it only finds the 1st item instead of say... 10 items.

thanks

[Plasma]

You can connect to any number of databases with php in the same page instance - you just need to handle the links.

For example, you may have something similar to:

$db1 = mysql_connect(...);

To connect to db1 - Now, whenever you want to use db1 for anything (such as a query), you would use:

$result = mysql_query($query, $db1);

Thats sending a query using the connection of db1.

So obviously, create a $db2 link and reference it when you want to issue queries to that database.

Look at php.net/mysql_query and all other mysql_* functions, they all offer a 'link identifier' parameter, which is the $db1 variable you pass to them which you get returned from a mysql_connect call.