Login Using Flash MX, PHP, and MySQL

Hello, i have a problem with the ‘Login Using Flash MX, PHP, and MySQL’ tutorial featured on the Kirupa website. (The tutorial can be loacted
Here

I have done all the Flash and PHP but the MySQL is wrong, the database SQL query doesnt work when i run it on my server, i have MySQL and PHP allowed on my server as i pay for it through silvesterhost.co.uk

Coild you tell me whats wrong with it? below is the SQL that is featured on the tutorial:

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

Hope you can help

Jason :ch:

what is your PHP code and what do you get for an error when your PHP page runs?

no its not the php that is wrong its the SQL query , when i run it in my control panel on my host it says errors, is there something wrong with the SQL? :tie:

what are the errors.