[SOLVED] Create Tables with PHP

[timmah1]

Can you please try and tell what I'm doing wrong here?

I keep getting this 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 ''pg_conditions'( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)' at line 1

 

Here is the script

mysql_query("CREATE TABLE ".$_POST['link']."'(
id INT NOT NULL AUTO_INCREMENT, 
INDEX KEY(id)
")
or die(mysql_error());  

echo "Table Created!";

 

Thank you in advance

[revraz]

$table=$_POST['link'];

mysql_query("CREATE TABLE '$table' (

id INT NOT NULL AUTO_INCREMENT,

INDEX KEY(id)

")

or die(mysql_error()); 

 

[wildteen88]

use backticks when defining field/table names within your query and not single quotes:

mysql_query('CREATE TABLE `'.$_POST['link'].`'( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)")  or die(mysql_error());  

echo "Table Created!";

[timmah1]

I copied that identical to what you put revraz, and I get this

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 ''pg_conditions' ( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)' at line 1

[shocker-z]

use

 

mysql_query('CREATE TABLE `'.$_POST['link'].`'( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)')  or die(mysql_error()); 

 

you had a stray " instead of '

 

 

Regards

Liam

[papaface]

use backticks when defining field/table names within your query and not single quotes:

mysql_query('CREATE TABLE `'.$_POST['link'].`'( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)")  or die(mysql_error());  

echo "Table Created!";

Should be:

mysql_query('CREATE TABLE `'.$_POST['link'].'` ( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)')  or die(mysql_error());  

echo "Table Created!";

[shocker-z]

didnt see that paperface so this is what u need mate..

 

 

mysql_query('CREATE TABLE `'.$_POST['link'].'` ( id INT NOT NULL AUTO_INCREMENT, INDEX KEY(id)')  or die(mysql_error());  

 

Liam

 

[timmah1]

Thanks for all the replies, but I'm getting this error now

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 'KEY(id)' at line 1

[papaface]

try:

mysql_query('CREATE TABLE `'.$_POST['link'].'` ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id)')  or die(mysql_error());  

[timmah1]

This is confusing the hell out of me.

I tried that papaface, but got the 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 '' at line 1

[papaface]

What does $_POST['link'] contain?

[timmah1]

It contains a link field, right now, for this code

The $_POST['link'] is pg_conditions

 

I saw somewhere else that the code looked like this

mysql_query('CREATE TABLE `back`,`'.$_POST['link'].'` ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id)')  
or die(mysql_error());  

With back being the database name, but that gives me this 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 '`pg_conditions` ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id)' at line 1

[timmah1]

I got it to work, it was missing one )

 

mysql_query('CREATE TABLE `'.$_POST['link'].'` ( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id))')  
or die(mysql_error());  

[timmah1]

Thanks to everyone who helped me.

 

Have a great Holiday!!!