I have just run into a baffling error. I have a database set up in MySQL with six tables. My PHP based website performs queries of all kinds on these tables (SELECT, INSERT, UPDATE, DELETE).

On my most recently setup table, the "Orders" table, I am able to perform queries from the server, as well as from my PHP MySQL Admin interface, but all activity from my webpage states that the Orders table does not exist. All other tables are running fine.

I have tried rewriting the query script, checked for case sensitivity problems, even cut and pasted other working scripts in place, changing the table and field names as needed. No success.

What could cause a single table to not show up like this?

I found out my issue was with my hosting company. I kind of figured as much in the back of my mind. I definitely spent some time bashing my head on the desk trying to work around it anyway.

Sure. It's extremely common for web hosting providers to block specific mysql tables. Usually by IP address. But often by phase of moon. Or humidity level. But only on specific days of the month

!Not!

So, like, what WAS the problem, dude?

And how was it resolved?

Inquiring minds definitely want to know!