Help

[nomad9]

I don't understand what wrong :

// Create Form Variable
$clientRef = $POST['clientRef'];
$clientName = $POST['clientName'];

// Create Table
$sql = "CREATE TABLE ".$clientRef." (formID AUTO_INCREMENT PRIMARY KEY,";
$sql .= "formType TEXT NOT NULL,";
$sql .= "formName TEXT NOT NULL,";
$sql .= "formQuestion TEXT NOT NULL,";
$sql .= "formValue TEXT NOT NULL)";

$result = mysql_query($sql,$db) or die(mysql_error());

// End DB Connection
mysql_close();
?>

Please help ...

[hand]

$sql = "CREATE TABLE ".$clientRef." (formID int(11) AUTO_INCREMENT PRIMARY KEY,"; 
$sql .= "formType TEXT NOT NULL,"; 
$sql .= "formName TEXT NOT NULL,"; 
$sql .= "formQuestion TEXT NOT NULL,"; 
$sql .= "formValue TEXT NOT NULL)"; 

[nomad9]

Here's what I got :

You have an error in your SQL syntax near '(formID int(11) AUTO_INCREMENT PRIMARY KEY,formType TEXT NOT NULL,formName TEXT ' at line 1