Member Avatar for vssp

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

  • 2 Contributors
  • 2 Replies
  • 74 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by vssp
Member Avatar for pritaeas

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

Edited by pritaeas
Member Avatar for vssp

Thanks for your replay

vssp

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.