 |  |  |  |  |  |  |  |
multiple select database
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
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
•
•
Join Date: Jul 2006
Posts: 831
Reputation: 
Solved Threads: 136
Practically a Posting Shark
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
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
"If it is NOT source, it is NOT software."
-- NASA
-- NASA
|
Similar Threads
- collecting $_POST from a multiple select (PHP)
- insert multiple rows in database (MS SQL)
- Multiple Select List Handling (JSP)
- Send all items in a listBox to SQL server database table (ASP.NET)
- Multiple Tables in a Database (Visual Basic 4 / 5 / 6)
Other Threads in the PHP Forum
- Previous Thread: dynamic combo load problems
- Next Thread: opening files with read and write access
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array beginner binary body broken buttons cakephp checkbox class cms code cron curl database date date/time display dynamic ebooks echo email error file files folder form forms function functions global google href htaccess html image include insert ip javascript joomla limit link list login mail mediawiki menu mlm msqli_multi_query multiple mycodeisbad mysql number oop parameter paypal pdf php phpincludeissue phpmyadmin problem query radio random recursion remote script search seo server sessions sms soap source sp space speed sql static subdomain syntax system table tag tutorial update upload url validator variable vbulletin video web webdesign white wordpress xml youtube
