dannygoor Posted June 5, 2007 Share Posted June 5, 2007 I have to MySQL databases, DB1 and DB2, DB1 is a myspace type database, DB2 is a shopping cart. users can access the shopping cart thru their page, however, being that they are different DB's users have to recreate all their information. I was wondering if there was a way for DB2 to get all the user information from DB1? thanks Quote Link to comment https://forums.phpfreaks.com/topic/54348-use-table-from-other-db/ Share on other sites More sharing options...
btherl Posted June 6, 2007 Share Posted June 6, 2007 You can copy the information over.. or you can access DB1 from the same script that accesses DB2. Without more information I can't advise you on details. One option would be to trigger copying of the information only when someone needs the data. FYI, many people think only one mysql database can be used from one script. In fact, you can connect to as many as you want, but you must pass the right "handle" (that you get from mysql_connect()) with each query, to say which database you want to use. Quote Link to comment https://forums.phpfreaks.com/topic/54348-use-table-from-other-db/#findComment-269003 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.