Login system - problem!

programming flash
1

Hi i’ve tried to prepare a windowed app which is responsible for login - im using php and mysql base ( 1 table:users; table users is simple: $id,$username,$password). This is flex code of app:


<?xml version="1.0" encoding="utf-8"?>
<mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" backgroundGradientAlphas="[1.0, 1.0]" backgroundGradientColors="[#67758F, #67758F]" width="600" height="400" horizontalAlign="center" verticalAlign="middle">
    
    <mx:Script>
        <![CDATA[
        import mx.rpc.events.ResultEvent;
        import mx.controls.Alert;
            private function login():void 
            {
                loginservice.send();
            }
            
            private function onResult(e:ResultEvent):void
            {
                if (e.result.status == true) 
                {
                    Alert.show("hurra!", "Success");
                }
                else
                {
                Alert.show("buba!", "Failure");
                }
            }
        ]]>
    </mx:Script>
    <mx:HTTPService id="loginservice" url="http://skaba.2ap.pl/mylogin.php" showBusyCursor="true" method="post" result="onResult(event)">
            <mx:request xmlns="">
                <user>(txtUser.text)</user>
                <pass>(txtPass.text)</pass>
            </mx:request>    
    </mx:HTTPService>
    <mx:Panel width="250" height="200" layout="absolute" title="Login" horizontalAlign="left" verticalAlign="middle" x="174" y="99">
        <mx:Text x="10" y="24" text="Username"/>
        <mx:Text x="10" y="73" text="Password"/>
        <mx:TextInput x="35" y="46" maxChars="50" id="txtUser"/>
        <mx:TextInput x="35" y="96" displayAsPassword="true" id="txtPass" maxChars="50"/>
        <mx:Button label="Submit" x="154" y="128" click="login()"/>
    </mx:Panel>
    
</mx:WindowedApplication>

nad php:

<?php

define( "DATABASE_SERVER", "localhost" );

define( "DATABASE_USERNAME", "skaba_skaba" );

define( "DATABASE_PASSWORD", "pass" );

define( "DATABASE_NAME", "skaba_base" );

//connect to the database

$mysql = mysql_connect(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD) or die(mysql_error());

//select the database

mysql_select_db( DATABASE_NAME );

//asign the data passed from Flex to variables

$username = mysql_real_escape_string($_POST["username"]);

$password = mysql_real_escape_string($_POST["password"]);

//Query the database to see if the given username/password combination is valid.

$query = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";

$result = mysql_fetch_array(mysql_query($query));

//start outputting the XML

$output = "<loginsuccess>";

//if the query returned true, the output <loginsuccess>yes</loginsuccess> else output <loginsuccess>no</loginsuccess>

if(!$result)

{

$output .= "no";        

}else{

$output .= "yes";    

}

$output .= "</loginsuccess>";

//output all the XML

print ($output);

?>

and sth is wrong because when im trying to login everytime the alert is: buba (wrong password ). When i place a correct pass and username too. ;/ Where is the main problem?