I'm fairly sure database names are only restricted by characters allowed in a filename on whatever OS MySQL is on.
USE `anime-soup_com_-_chatting` (note: those are backticks [top left key on most keyboards], not single-quotes) That should work fine, and is probably exactly what mysql_use_db() is doing for you. Chris -----Original Message----- From: Stephen Craton [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 7:41 PM To: Jason Wong Cc: PHP List Subject: Re: [PHP] Cannot Use Database Found the problem. I was using the query of "use database_name" rather then the defined function given out by PHP. Some systems don't have the permission to do the use command I suppose. ----- Original Message ----- From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 10, 2003 7:34 PM Subject: Re: [PHP] Cannot Use Database > On Thursday 11 December 2003 06:17, Stephen Craton wrote: > > > I am having an issue connecting to a MySQL database. I've made a script > > that installs itself to a MySQL database (creates all the tables and such) > > and then the script uses the tables to store information and whatever else > > it may have to do. > > > > The problem is, the install works just fine, > > Are you sure? > > > but when I try to access the > > database through the script later on, it outputs the following: > > > > Database error: cannot use database anime-soup_com_-_chatting > > AFAIK, you cannot use hyphens in the database name. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > ------------------------------------------ > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-general > ------------------------------------------ > /* > I just had a NOSE JOB!! > */ > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
