[SOLVED] Is this possible? Create a Table from a Variable?

[CoreyR]

I'm trying to create tables from username, is this possible? I would think it was, but I know I have the syntax wrong. Thanks for helping.

 

$query = 'CREATE TABLE "$username"( '.
         'cid INT NOT NULL AUTO_INCREMENT, '.
         'cname VARCHAR(20) NOT NULL, '.
         'cemail VARCHAR(50) NOT NULL, '.
         'csubject VARCHAR(30) NOT NULL, '.
         'cmessage TEXT NOT NULL, '.
         'PRIMARY KEY(cid))';

 

[pocobueno1388]

I don't see why it wouldn't be possible...

 

Here is a website that will show you the correct syntax:

http://www.w3schools.com/php/php_mysql_create.asp

[CoreyR]

Ya, I've been there. That only shows how to create a database and a table, but not using a variable.

 

Thanks

[pocobueno1388]

Just replace the table name with the variable....

 

CREATE TABLE $username
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
.......
)

[CoreyR]

Perfect, thank you. I tried that earlier but I believe I had a syntax error which wasn't allowing me to create the table with or without using the variable. Thanks for the help guys!

 

Corey R.