Fla not connecting to database :(

original post is here http://kirupa.com/forum/showthread.php?p=2208220#post2208220

actionscript 2 / flash 8 file

hi again, all was well for a while, I got the script to work perfectly, even got to register a few hundred members to the site. However, my old host had a bandwidth limit of 400gb so I had to move to a new provider. I transferred all the files with no problems, and even setup the database properly. My new problem is registering… I can login just fine using an existing account I had made. But I go to try and make a new account and I get an “undefined” error.
here is the link to the site, i have setup a test folder which can access the database.

http://www.pastrykicks.com/test/login.html

also here is the php code. .harish, you’re absolutely correct. The indenting helps a lot.

edited - php code removed after concluding that was not the problem.

the problem either lies with the host blocking something or the swf itself. I’m no programmer so I am stumped.

Here is the login.fla file for any coders can check it out if they’d like.
was too big to attach to the forum. 283kb
http://www.pastrykicks.com/login.zip