What is wrong with this code? Whats happening is its getting variables from a previous page and inserting them into a table. Based on those values, it creates a table. It inserts the values but does not create the table. What happened????
$name=$POST['name'];
$title=$POST['title'];
$description=$_POST['description'];
mysql_connect(localhost,*,);
$Database="***";
@mysql_select_db($Database) or die("Unable to select database");
$query="INSERT INTO forums VALUES('','$name','$title','$description')";
mysql_query($query);
$sql = "CREATE TABLE $name ( 'id' INT( 6 ) NOT NULL AUTO_INCREMENT, 'topic' VARCHAR( 50 ) NOT NULL , 'tstarter' VARCHAR( 10 ) NOT NULL , 'tstart' VARCHAR( 45 ) NOT NULL , 'replyu' VARCHAR( 10 ) NOT NULL , 'replyn' VARCHAR( 50 ) NOT NULL , 'replyt' VARCHAR( 45 ) NOT NULL , 'replym' BLOB NOT NULL , 'reply' CHAR( 1 ) NOT NULL , PRIMARY KEY ( 'id' ) ); ";
mysql_query($sql);
mysql_close();
