Why Do I get This Error
 

and how can i fix it....

this is wat it says when i try to make a table

SQL-query :

CREATE TABLE `download` (`id` MEDIUMINT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `userid` MEDIUMINT(10) NOT NULL, `link` MEDIUMTEXT(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DATE(20) NOT NULL)

MySQL said:

You have an error in your SQL syntax near '(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DA' at line 1

E just take the mediumtext(100) and change it to mediumtext... when i use that i don't define it with a value but i could be wrong... regards...

g-force2k2

i will try it
thx

btw E if you wanted to set a limit just change the mediumtext to varchar(100) regards ;)

g-force2k2

Hmmm...there is nothing wrong with that query. I would remove the apostrophes as this seems to be causing issues for some people and has been verified.