Hey, im having a problem with the tutorial located @ http://www.kirupa.com/developer/actionscript/authentication.htm when i run the SQL query in phpmyadmin it returns with this error:
[COLOR=red]
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. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO_INCREMEN
[/COLOR]
What is wrong with the query?
please reply.
Jay
