dynamicly creating tables within db

dburgessjr

howdy, folks!
i was wondering if someone could help me out with the problem? i want to set up a form that allows me/someone else to dynamicly create tables within a certain database. this is what i have for the script:

<body>
<?
$user = "*****";
$pass = "*****";
$db = "dburgess_pacterole";
$global = "";
$link = mysql_connect ("localhost", $user, $pass);
$add_table = CREATE TABLE .$tablename 
( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`pname` CHAR(40) NOT NULL,
`pposition` CHAR(40) NOT NULL, 
`prole` CHAR(40) NOT NULL 
);

if (!link)
	die ("Couldnt connect to the MySQL");
	print "Successfully connected to server <br>";

mysql_select_db ($db)
	or die ("Couldnt open $db: ".mysql_error ());
	print "Successfully connected to the database <br>";

//mysql_close ($link);

if (isset ($tablename)) {
	mysql_query ($add_table, $link)
		or die ("Couldnt add the new table to the database");
	$global = "Table name, $tablename has been created";

}
else {
?>
<form method="post">
<input type="text" name="tablename">
<input type="submit" name="submit" value="add table!">
</form>
<?
}
?>
</body>

i keep getting parse errors on line 15. and on line 15 is the: $add_table = code. what i would like is for the table name be taken from the input box and created for me. i am hopeing this can be done.

altexis

The parse error is because you need to call it in a different way:

$add_table = mysql_query("CREATE TABLE $tablename 
( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`pname` CHAR(40) NOT NULL,
`pposition` CHAR(40) NOT NULL, 
`prole` CHAR(40) NOT NULL") or die(mysql_error());

But apart from that you must first select the database, then create the table. So you should rewrite your code to:

$link = mysql_connect ("localhost", $user, $pass) or die("Couldnt connect to the MySQL: ".mysql_error());
mysql_select_db ($db)
    or die ("Couldnt open $db: ".mysql_error ());
$add_table = mysql_query("CREATE TABLE $tablename 
( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`pname` CHAR(40) NOT NULL,
`pposition` CHAR(40) NOT NULL, 
`prole` CHAR(40) NOT NULL") or die(mysql_error());

dburgessjr

ok, thank you.