[SOLVED] create mysql table in php

[daveh33]

Trying to create a mysql table - I have the below code so far: -

 

$name = $_POST['name'];
$newtablename = "$name_numbers";
$query1="CREATE TABLE $newtablename (number varchar(11) NOT NULL)";
$result = mysql_query($query1) or die(mysql_error());

 

What I am trying to do - is use the POST data to create a table E.G Orange_numbers

                              - There is only 1 field required in the table, called number

 

I just get the below error: -

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(number varchar(11) NOT NULL)' at line 1

 

[Ken2k7]

$newtablename = "$name_numbers";

 

What's $name_numbers? That variable isn't defined.

[daveh33]

I have the variable $name defined, I want it to use that input and add "_numbers"

e.g create table name: test_numbers

[Ken2k7]

Try this:

 

$name = $_POST['name'];
$newtablename = $name."_numbers";
$query1="CREATE TABLE $newtablename (number varchar(11) NOT NULL)";
$result = mysql_query($query1) or die(mysql_error());

 

If you just say $name_numbers, that's the whole variable.

[daveh33]

Works perfectly - many thank Ken!