login funktion med php/mysql

Script i 1. frame:

stop();
userinput.restrict="a-zA-Z0-9";
passinput.restrict="a-zA-Z0-9";
Selection.setFocus(userinput);
status="Enter your information and submit";
this.onEnterFrame = function () {
    if(_root.checklog == 1){
        _root.gotoAndStop(2);
    }
    if(_root.checklog == 2){
        _root.gotoAndStop(3);
    }
}

script på submit-knap:

on (release, keyPress "<Enter>") {
    if (user != "" && pass != "") {
        status = "Begin Login Process - Wait...";
        loadVariablesNum("newlogin.php", 0, "POST");
    }
}

php-dokumentet:

<?
$user=$_POST['user'];
$pass=$_POST['pass'];


if ($user && $pass){
    mysql_pconnect("mysql.yourhost.com","yourusername","yourpassword") or die ("didn't connect to mysql");
    mysql_select_db("yourdatabase") or die ("no database");

$query = "SELECT * FROM yourtable WHERE username = '$user' AND userpassword = '$pass'";
$result = mysql_query( $query ) or die ("didn't query");


$num = mysql_num_rows( $result );
if ($num == 1){
    print "status=You're in&checklog=1";
    } else {
    print "status=Sorry, but your user name and password did not match a user name/password combination in our database.  Usernames and passwords are entered in from a different file.  Thank you for visiting test login script!!&checklog=2";
}
}

?>