Posted by Harold on 06/11/06 12:43

Hello J.O. Aho,

> Rik wrote:
>
>> Harold wrote:
>>
>>> Is it possible to use more than one database ( large web
>>> application) on the same web page
>>>
>> Yes. Do you mean more than one database on the same or several
>> servers?
>>
>>> if so how whould i go about it
>>>
>> Same server, same rights for the user on the 2 db's:
>> Don't use mysql_select_db()
>> Use queries like:
>> SELECT * FROM database1.table
>> Different servers, or different users
>> $db1 = mysql_connect($server1,$name1,$pass1);
>> $db2 = mysql_connect($server2,$name2,$pass2);
> you can do
> mysql_select_db('database1', $db1)
> mysql_select_db('database2', $db2)
> and you don't have to specify the database name in the queries.
>
> //Aho
>


Ok - Thanks to both that responded - BTW it was for same server

Thanks again

• Next in forum: separate mysql "sections"?
• Prev in forum: Re: multiple databases ( php and mysql)
• Thread view: Re: multiple databases ( php and mysql)

[Reply to this message]