Creating Table from input

[eugene2009]

having a problem.. how can i create a table in a mysql database from a users input?

CREATE TABLE contact( '.
         '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))';

Say i have a text input on the previous page named "tablename" why doesnt it still work? Please help.

[johanafm]

What does your php code look like?

[eugene2009]

Lets make it simple....

// network.php


<form action="network_results.php" method=post>

     <input type=text name="tablename">
     <input type=submit value="go!">

</form>

// network_results.php

<?

mysql_connect("localhost", "XXXX", "XXXXX") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

mysql_query(CREATE TABLE $tablename( '.
         '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))';

echo "Table Created!";

?>

[rincewind456]

mysql_query(CREATE TABLE $tablename( '.
         '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))';

Is wrong, you need a closing bracket and some enclosing quotes.

And unless your using register globas, which you shouldn't be, then $tablename in your network_results.php file should be

 $_POST['tablename']

[eugene2009]

stillll... doesnt work. i tried every possible way there is.

[johanafm]

Obviously not, or it would work. It should work with rincewind's suggested changes. What does your code look like now?

[eugene2009]

Nvm.. Figured it out.. Thanx