:'( MYsql version problem

Ok! i keep posting this kind of question lol but i dont get any replies!!! ok well i have done the tutorial featured @ http://www.kirupa.com/developer/actionscript/authentication.htm and i cant test it out because the SQL query wont work!

I asked around and found out that the SQL query featured on this page will not work on the version of SQL i have!

I have no knowledge of SQL and wondered if someone could help me out by changing the query featured on the page to the version of SQL i have. the version i have is MYsql 4.0.18-standard. The query featured on the page is:

CREATE TABLE auth (
userid
int(4)
unsigned
zerofill
DEFAULT ‘0000’
NOT NULL
auto_increment,
username varchar(20),
userpassword varchar(20),
PRIMARY KEY (userid)
);

If you are wondering what the error is whati get when i run the query its:

#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 '( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO_INCREMEN

Please help :ne:

Jay