Page 1 of 1

MYSQL Help Please :(

Posted: Sun Apr 04, 2004 6:54 pm
by Mat^_^
I'm having trouble with my database, it connects to it fine but it wont recognise the tables.

For example the database is named 'pingsports_com_-_main' and an example of a table name is 'members'. When you goto the website i get the following error:

Fatal Error: Database Error!
- Table 'pingsports_com_-_main.members' doesn't exist

The tables inside the database have no prefix, as i said above they are simply called 'members', 'news' etc.

Could anyone please shed some light on the problem of why it wont read the tables.

Regards

Mat.

Posted: Sun Apr 04, 2004 9:07 pm
by markl999
I'd rename that database as - is an illegal character in a database name. You can continue to use it but you'll have to backquote the database name everywhere you want to refer to it, eg `pingsports_com_-_main`

Posted: Sun Apr 04, 2004 11:17 pm
by Mat^_^
I'll give that a try, thanks.