Multiple MySQL Databases and mysql_select_db problem
Posted: Fri Jul 19, 2002 8:27 pm
I've been working on one project for about six months now and recently decided to start on another when I ran into an aweful confusion: I don't remember setting up the first database and have no recollection of what I did to get the login and password set... I initially thought I would be able to use the same login and password for a second database but I can't get it to work from PHP (I can in the command dialog). What am I forgetting? Both databases are there and both have data in them, however I can only connect to the first. I'm pretty sure I didn't set any grants/permissions to any specific user since I'm relatively new to this. The error I get is the one I coded (echo...) when the mysql_select_db function does not return true. A friend of mine suggested that this might be caused by a connection already existing to the first project, however I'm not so sure that would be true since I have tested it upon reboot. I am using persistent connections (mysql_pconnect) though. The funny thing is that my first project still works fine. HELP!