Another CREATE TABLE question ...

nomad9

I'm trying to pass a variable from a form. This variable use to be the name of the table I want to create :

// Create Form Variable
$clientRef = $_POST['clientRef'];

$sql = "

CREATE TABLE ".$clientRef." (id int NOT NULL auto_increment,date varchar(20) NOT NULL,prenom varchar (50) NOT NULL,email varchar(55) NOT NULL,PRIMARY KEY (id))

mysql_query($sql);

But it doesn't work .... I think that the ".$clientRef." is not working cause if I test this :

$sql = "

CREATE TABLE TESTTABLE (id int NOT NULL auto_increment,date varchar(20) NOT NULL,prenom varchar (50) NOT NULL,email varchar(55) NOT NULL,PRIMARY KEY (id))

mysql_query($sql);

... it work well

*** Another question ... it is possible to give number to table name (ex. 55688)

Steve

cgraz

$sql = " 
CREATE TABLE TESTTABLE (id int NOT NULL auto_increment,date varchar(20) NOT NULL,prenom varchar (50) NOT NULL,email varchar(55) NOT NULL,PRIMARY KEY (id)) 
";

works but

$sql = " 
CREATE TABLE ".$clientRef." (id int NOT NULL auto_increment,date varchar(20) NOT NULL,prenom varchar (50) NOT NULL,email varchar(55) NOT NULL,PRIMARY KEY (id)) 
";

doesn't, and the only thing changed is the variable, then the variable is your problem. Echo out the variable on your page until you get it to display something. When it echo's properly, then your script should work.


echo "Table Name " . $_POST['clientRef'];

// are you using post on your form? If not, try

echo "Table Name " . $_GET['clientRef'];

// or just

echo "Table Name " . $clientRef;

Hope that helps.

Cgraz

[deleted]

Take note that in new versions of PGP you have to use the superglobal arrays $GET and $POST to get data from a GET or POST operation.

PS, it is not a good idea to just use the var for the tablename. Always check the name for validity, always, even if you use a password to logon, and even if you are the only person using it. It is far too easy to type the wrong name and accedently while out your database.

nomad9

Hi,

I echo the variable and nothing happen :

echo "Table Name " . $_POST['clientRef'];

// are you using post on your form? If not, try

echo "Table Name " . $_GET['clientRef'];

// or just

echo "Table Name " . $clientRef;

and the result is :

Table Name Table Name Table Name ????

It seem that the variable doesn't work ... 😕

I'm a newbie with php/mysql so now i'm very confused !!!

what a "SUPERGLOBAL ARRAY" CAN someone give me an example

steve