Create table ...

[nomad9]

Hi,

can someone tell me what's wrong with this code :

<?
// Start DB Connection
$db = mysql_connect('localhost', 'levesque', 'nomad');
mysql_select_db('visionclient_ca',$db);

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

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

// End DB Connection
mysql_close();
?>

Thanx Steve

[jerdo]

$sql = "CREATE TABLE "$clientRef" (formID varchar(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,"; 

Should be

$sql = "CREATE TABLE $clientRef (formID varchar(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,"; 

Or

$sql = "CREATE TABLE ".$clientRef." (formID varchar(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,"; 

[Sore]

Here you made a fault by $clientRef. Should be:

$sql = "CREATE TABLE ".$clientRef." (formID varchar(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,";

And maby you cut this line but it should be:

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

[nomad9]

Thanx alot guys !!! 😃

[nomad9]

Thanx alot guys !!! 😃

[nomad9]

I try this :

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

// Create Table
$sql = "CREATE TABLE ".$clientRef." (formID varchar(5) NOT NULL 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();
?>

and here's what I've got :

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

????