sql syntax error

[thesavior]

My query:

CREATE TABLE '.$db_prefix."tutorials (
id INT(30) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(80) NOT NULL,
desc VARCHAR(100) NOT NULL,
poster VARCHAR(20) NOT NULL,
clicks INT(30) NOT NULL,
category VARCHAR(60) NOT NULL
) TYPE=MyISAM;

Is giving me an error of:

You have an error in your SQL syntax near 'desc VARCHAR(100) NOT NULL, poster VARCHAR(20) NOT NULL, clicks INT(30) ' at line 4 (Errno: 1064)

[GJay]

'desc' is a reserved word.

[vinyl-junkie]

Taking into consideration GJay's post, I believe you still have some syntax problems with this. I've turned it into the PHP statement that I'm guessing you want it to be:

$sql = "CREATE TABLE ".$db_prefix."tutorials (
id INT(30) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(80) NOT NULL,
descript VARCHAR(100) NOT NULL,
poster VARCHAR(20) NOT NULL,
clicks INT(30) NOT NULL,
category VARCHAR(60) NOT NULL
) TYPE=MyISAM";

[thesavior]

no, i had no syntax error, and it was used in a function, so i didn't need to show you everything, just the query. But thanks for checking vinyl-junkie

[Brandoe85]

You can also place the desc in backticks `desc` and it should work.

Good luck;