John-Marc,
I have a store db, and a hosting/billing db. I want to create a customer account area on my website where my clients can login and view their printing (store db) and hosting (hosting db) invoice history, as well as update their address/phone, etc all within their client profile.
I'm thinking maybe I should create a member db like the script I mentioned has, and add the clients from both db into the member db as this would let me have only 1 db for client contact info. Then once they are logged in query the other 2 db to display content based on which db they appear in. Does that make sense?
Hopefully a simple/stupid question... if I connect and query db1 and have a result set of result1 and then connect and query db2 and have a result set of result2... Can I use both vars (result1 and result2) even after the connections are closed?