accessing 2 mySQL databases on one page

Shauna

I seem to be getting a conflict when trying to access two sepearte databases on one html page... I am using "mysql_select_db" for both. Should I be doing something different?

Thanks!

MBK

What error message are you getting, and what is your script like.
I am trying to access 2 Mysql databases using a script and am not getting anything, post your script and maybe we can work this out between us and with everyone elses help.

Thanx.

jerdo

When accessing two databases on the same page try connecting to the first one and getting/writing the data you need to go into that db then connect to the second one.

frigidman

A way i've done it in the past to work with even three entirely different databases... is I used a special class object that contained all the mysql functions, and actions setup with connection info for each database. I would load this class into a different var for each different database.

This object file is located here for download... if this forum supports that properly (we'll see!!).

mrmufin

If you write your code carefully, by using the optional connection ID parameters within your select_db() function, you should have no problems.

Be sure to specify in both the select_db() and query() functions which database connection you're using. There's no need to use an abstraction class (although it is definitely a useful utility to have in your code arsenal!), nor do you need to do stuff on one database, then the other. Just be careful when writing the code and you should have no problem concurrently connecting to and querying multiple MySQL databases.

Good luck...

frigidman

(although it is definitely a useful utility to have in your code arsenal!)

Thanks :eek:

I just got so tired of how messy all those mysql functions and calls get, and all the copy/pasted code, was adding needless lines to my php apps. So, I constructed that object from various bit n pieces I found round the net, and throw it into a global include directory for apps. I'm just lazy when it comes to duplicate code 😃