# Login using php and mySQL

**URL:** <https://forum.kirupa.com/t/login-using-php-and-mysql/45737>\
**Category:** programming\
**Created:** [March 17, 2004, 5:34pm UTC](https://forum.kirupa.com/t/login-using-php-and-mysql/45737 "2004-03-17T17:34:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmayo86](https://avatars.discourse-cdn.com/v4/letter/j/94ad74/32.png) [@jmayo86](https://forum.kirupa.com/u/jmayo86)\
**Post date:** [March 17, 2004, 5:34pm UTC](https://forum.kirupa.com/t/login-using-php-and-mysql/45737/1 "2004-03-17T17:34:28Z")

</div>

Hey, im having a problem with the tutorial located @ [http://www.kirupa.com/developer/actionscript/authentication.htm](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