MYSQL Help Please :(

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Mat^_^
Forum Newbie
Posts: 2
Joined: Sun Apr 04, 2004 6:54 pm

MYSQL Help Please :(

Post 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.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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`
Mat^_^
Forum Newbie
Posts: 2
Joined: Sun Apr 04, 2004 6:54 pm

Post by Mat^_^ »

I'll give that a try, thanks.
Post Reply