Can't CREATE TABLE (Mysql)

a very simlar script works well ..

[Syco23]

Hi,

This Code works:

$setup = "CREATE TABLE lyrics (
id INT( 255 ) UNSIGNED NOT NULL AUTO_INCREMENT,
url VARCHAR( 20 ) NOT NULL ,
kurz VARCHAR( 2 ) NOT NULL ,
tracknr INT( 2 ) NOT NULL ,
titel VARCHAR( 50 ) NOT NULL ,
text TEXT NOT NULL ,
songwriter VARCHAR( 2 ) ,
PRIMARY KEY ( id )
)";

This one doesn't work:

$setup = "CREATE TABLE alben (
id INT( 255 ) UNSIGNED NOT NULL AUTO_INCREMENT,
kurz VARCHAR( 2 ) NOT NULL ,
name VARCHAR( 50 ) NOT NULL ,
jahr INT( 4 ) NOT NULL ,
tracks INT( 2 ) NOT NULL ,
amazon VARCHAR( 255 ) NOT NULL ,
desc TEXT NOT NULL ,
PRIMARY KEY ( id )
)";

[olwen]

DESC is a reserved word I think. Try DESCR instead.

[Paul in South Africa]

olwen is correct.

For a full list of reserved word see h*tp://www.mysql.com/doc/en/Reserved_words.html