using apostrophe's in table names...

[kaliok]

I am having trouble with the following:

if (!get_magic_quotes_gpc()) {
$testName=stripslashes(strip_tags(trim($_POST['ud_testname'])));}
else {$testName=trim($_POST['ud_testname']);}

$nameSquish = str_replace(" ","", $testName);

mysql_query("CREATE TABLE $nameSquish(
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
myNote TEXT,
myDate DATETIME,
noteBy VARCHAR(50))")
or die(mysql_error());


When I try to put in a name with an apostrophe (i.e. O'Reilly) in it the following error is given:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\'Reilly( ID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID),

However when I do a echo $nameSquish before the SQL query, it comes back with:

O\'Reilly

Could someone help me find a way to create a table with the apostrophe still in the name.

Thanks.

[fenway]

I really hope that you can't... you could try using backticks (`) and see what happens.