"SHOW TABLES FROM $database" doesn't work with underscores?workaround?

[carsten888]

SHOW TABLES FROM '".$database_name."' 

I need to test for the existence of a table in the database. This query works fine as long as there are no underscores in the database-name.

Is there a workaround so that this script could deal with underscores in database-names?

[Readie]

Backticks, not quotes :)

$sql = 'SELECT TABLES FROM `' . $database_name . '`';

[Readie]

SHOW TABLES FROM**

Typo sorry, I was a little hung over when I wrote that :)

[bizminder]

Just enter a row into the table assuming it exists, if the row is successfully added then it exists else it does not exist.

[Matthew1980]

This is the trouble with duplicates:-

[webmasterworld.com ]

Solved.