PHPMyAdmin - #1064 - You have an error in your SQL syntax

[andz56]

Hey guys,

im new to php and mysql etc. but on setting up a database on my host using phpmyadmin i keep getting the following error: -

#1064 - 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 '(300), PRIMARY KEY (`ID`))' at line 1

Here is the database code: -

CREATE TABLE `projects` (

`ID` INT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`Title` VARCHAR( 20 ) ,
`Article` BLOB( 300 ) ,
PRIMARY KEY ( `ID` )
)

The host runs MYSQL 4.0.15, any suggestions/help anyone please?

 

[andz56]

mate, your a star, this has worked a treat,

what is MYISAM?

 

[andz56]

thanks, ill look into that,

thanks again