Login Using Flash MX, PHP, and MySQL

hey people

i hope somebody can help me, i have the following problem i followed the tutorial and that wasn’t that easy for me because it is my first day using flash :D.

everything works login, creating new user, bad login error but when i type the good login it says youre in and after that nothing happend…

he does not jump to the following keyframe the same problem by using the wrong login he will not jump to another keyframe…

what can i do about this

remember this is my first day using flash so be not to hard for me :smiley:

hi i have the same problem

my msn address is keithey56@hotmail.com please can someone help I can give you fla file if you like

please help i need to get this site going its on http://members.lycos.co.uk/netmobile/

andy

any progress with this?

I really need this to work.
here is the code I’m using:

stop();
userinput.restrict = "a-zA-Z0-9";
Selection.setFocus(userinput);
passinput.restrict = "a-zA-Z0-9";
this.go_mc.submit.onRelease = function() {
if (user != undefined && pass != undefined) {
stat = "Verifying";
myLoadVars = new LoadVars();
myLoadVars.user = user;
myLoadVars.pass = pass;
myLoadVars.sendAndLoad("newlogin.php", this, "POST");
myLoadVars.onLoad = function(success) {
if (success) {
if (checklog == 1) {
gotoAndStop(13);
}
if (checklog == 2) {
gotoAndStop(14);
}
if (checklog == undefined) {
stat = "undefined";
}
} else {
stat = "Could not access Username Database. Please try again.";
}
};
}
};

and here’s my php file:

<?
$user=$_POST[‘user’];
$pass=$_POST[‘pass’];

//connect to database
if ($user && $pass){
mysql_pconnect(“localhost”, “<user>”, “<password>”) or die (“didn’t connect to mysql”);
mysql_select_db("<db>") or die (“no database”);
//make query
$query = “SELECT * FROM auth WHERE username = ‘$user’ AND userpassword = ‘$pass’”;
$result = mysql_query( $query ) or die (“didn’t query”);

//see if there’s an EXACT match
$num = mysql_num_rows( $result );
if ($num == 1){
echo “checklog = 1”;
} else {
echo “checklog = 2”;
}
}
?>

any ideas? I’ve spent 3 days on this.

-Joshua