creating a table with php

[jjfletch]

Hi, I'm trying to create a script that will create a mysql table named after a particular variable.

I tried the following, which isn't working:

$unm = "CREATE TABLE '$unm' (id INT(8) AUTO_INCREMENT NOT NULL PRIMARY KEY,
                                fn VARCHAR(255) NOT NULL,
                                ed TIMESTAMP,
                                et LONGTEXT)";
$result = mysql_query($query);

I also tried:

$unm = "CREATE TABLE $unm (id INT(8) AUTO_INCREMENT NOT NULL PRIMARY KEY,
                                fn VARCHAR(255) NOT NULL,
                                ed TIMESTAMP,
                                et LONGTEXT)";
$result = mysql_query($query);

which didn't work either.

Am I doing something wrong here?

[drew010]

perhaps

$unm = "CREATE TABLE......
$result = mysql_query($query);

has a bit to do with it. appears your query is stored in $unm but you are using $query as the variable in mysql_query.

[jjfletch]

my bad.... it's late and my I'm sleepy. Both query statements are named $query not $unm. Like so:

$query = "CREATE TABLE '$unm' (id INT(8) AUTO_INCREMENT NOT NULL PRIMARY KEY, 
                                fn VARCHAR(255) NOT NULL, 
                                ed TIMESTAMP, 
                                et LONGTEXT)"; 
$result = mysql_query($query);