multiple select database

Expand Post »

Hi friends
In my application i need to connect multiple database.First i connect one database and got the value then i connect another database to insert the values . If any possible to two database to connect single application .
Please send me your suggestion .

Thanks
vssp

Similar Threads

insert multiple rows in database in MS SQL
collecting $_POST from a multiple select in PHP
Multiple Select List Handling in JSP
Send all items in a listBox to SQL server database table in ASP.NET
Multiple Tables in a Database in Visual Basic 4 / 5 / 6

vssp

Reputation Points: 5

Solved Threads: 5

Junior Poster

Offline

197 posts
since Jul 2006

Permalink

Jul 26th, 2006

Re: multiple select database

you can use the following query:

INSERT INTO DB1.table1 (fieldlist) SELECT fieldlist FROM DB2.table2

From a php view you only need to mysql_connect, and you can skip the mysql_select_db

pritaeas

Sponsor

Featured Poster

Reputation Points: 556

Solved Threads: 732

Bite my shiny metal ass!

Offline

4,196 posts
since Jul 2006

Permalink

Jul 27th, 2006

Re: multiple select database

Thanks for your replay

vssp

vssp

Reputation Points: 5

Solved Threads: 5

Junior Poster

Offline

197 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: dynamic combo load problems

Next Thread in PHP Forum Timeline: opening files with read and write access

DaniWeb Message

Cancel Changes

User Name
Password