How Can i Connect More then one database

Damodhar wrote:

Quote: hi > how can i connect more then one database in the same project. >

Simple - just connect and save the result of the connection. This will
be a resource representing the connection; just use the appropriate
resource in all of your calls (virtually all database function calls
have an optional parameter being the connection resource).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
Join Bytes!
==================

On Sat, 15 Mar 2008 02:57:45 +0100, Jerry Stuckle
<jstucklex@attglobal.netwrote:

Quote: Damodhar wrote: Quote: >hi > how can i connect more then one database in the same project. >> > Simple - just connect and save the result of the connection. This will be a resource representing the connection; just use the appropriate resource in all of your calls (virtually all database function calls have an optional parameter being the connection resource).

Be aware though: of both databases are on the same database server, and
reachable with the same connection & user, it's often just more lucrative
to use full names for tables in queries, at least in case of MySQL.
--
Rik Wasmus

Be aware though: of both databases are on the same database server, and

Quote: reachable with the same connection & user, it's often just more lucrative to use full names for tables in queries, at least in case of MySQL.

True. But there are other reasons for multiple connections. I often have
a separate connection to the same database for error logging (lazily
initiated, not open by default). This allows my error handling code to
log errors to a table, even if the main code does a transaction rollback
later.

Best reards.

..oO(The Natural Philosopher)

Quote: >Jerry Stuckle wrote: > Quote: >Which means you're making multiple links to the database with the same >credentials, wasting system resources. >> >All 1k bytes of them probably. Tsk Tsk.

"Too many connections" is a quite common error, especially on shared
hosts with a lot of poorly written user scripts.

Micha

Michael Fesser wrote:

Quote: .oO(The Natural Philosopher) > Quote: >Jerry Stuckle wrote: >> Quote: >>Which means you're making multiple links to the database with the same >>credentials, wasting system resources. >>> >All 1k bytes of them probably. Tsk Tsk. > "Too many connections" is a quite common error, especially on shared hosts with a lot of poorly written user scripts. > Micha

Or poorly tuned kernels..

On Mar 15, 12:33 am, Damodhar <damu...@gmail.comwrote:

Quote: hi > how can i connect more then one database in the same project.

$connection = mysql_connect(normal params);
mysql_query(query, $connection);