for a large community site, it is preferable to divide your data over more than one database. so i have all my userdata in one db and all forum data in another.
in the forum a have a userid with each thread, and i of course want to display the nickname, which forces me to access the user database to query on the userid
so not just differect tables, but different dbs! how to switch?
i tried mysql_change_user, didn't work. also tried to close the connection and make a new conection to get the nick and then close that one again to re-open the forum connection. doesn't work either.
anyone any idea?
