I was trying to use the Freddy tute but get a error message with PHP admin 2.5.3
CREATE TABLE auth (
userid
int(4)
unsigned
zerofill
DEFAULT ‘0000’
NOT NULL
auto_increment,
username varchar(20),
userpassword varchar(20),
PRIMARY KEY (userid)
);
Error
SQL-query :
CREATE TABLE auth( useridint( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO_INCREMENT ,
username varchar( 20 ) ,
userpassword varchar( 20 ) ,
PRIMARY KEY ( userid )
)
MySQL said:
#1064 - You have an error in your SQL syntax near ‘( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO_INCREMENT ,username varc’ at line 1
Can anyone see whats wrong with the table creation script ?