[SOLVED] create table question

[sser]

Hi everybody,

How can I create a table where the name is a variable specified before?

 

The code snippet is..:

 

  $test_table = basename($array[$i], ".dat");

  #mysql_query($test_table);

echo $test_table;

 

 

$query = "CREATE TABLE '$test_table' (field1 INT, field2 CHAR(20) NOT NULL, field3 CHAR(50) NOT NULL)";

 

where $test_table is supposed to be the filename.

 

When I try running this code, the table is named as $test_table.

 

Thanks...

[fenway]

You want backticks, not quotes.

[sser]

Thank you!