# Login Using Flash MX, PHP, and MySQL

**URL:** <https://forum.kirupa.com/t/login-using-flash-mx-php-and-mysql/29725>\
**Category:** flash\
**Created:** [August 29, 2003, 7:59pm UTC](https://forum.kirupa.com/t/login-using-flash-mx-php-and-mysql/29725 "2003-08-29T19:59:55Z")\
**Posts on this page:** 4\
**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:** [August 29, 2003, 7:59pm UTC](https://forum.kirupa.com/t/login-using-flash-mx-php-and-mysql/29725/1 "2003-08-29T19:59:55Z")

</div>

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](http://www.kirupa.com/developer/actionscript/authentication.htm)

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](http://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:

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 29, 2003, 10:32pm UTC](https://forum.kirupa.com/t/login-using-flash-mx-php-and-mysql/29725/2 "2003-08-29T22:32:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 30, 2003, 9:03am UTC](https://forum.kirupa.com/t/login-using-flash-mx-php-and-mysql/29725/3 "2003-08-30T09:03:07Z")

</div>

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:

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 30, 2003, 12:12pm UTC](https://forum.kirupa.com/t/login-using-flash-mx-php-and-mysql/29725/4 "2003-08-30T12:12:12Z")

</div>

what are the errors.