[php][mysql]Problem with a session script

[222333]

My script works on sessions. It connects to MySQL Database and chooses a password. Something is wrong, because it doesn't work - it always shows "Pass or login wrong".

PHP Code:

<form action="index.php" method="post"><input type="text" name="login" /><br />
<input type="text" name="pass" /><input type="submit" value="send" /></form>
<?php

$conn=mysql_connect("localhost", "root", "krasnal");
mysql_select_db("pass");
$choose="SELECT `cpass` FROM `pass`";
$r = mysql_query($choose);
$wynik = mysql_fetch_array($r);

if(!empty($_POST['login']) && !empty($_POST['pass']))
{
    if($_POST['login']=='login' && $_POST['pass']==$choose['cpass'])
    {
    $_SESSION['logged']=$_POST['login'];
    echo 'logged';
    }
    else
    {
    echo 'Pass or login wrong!!!';
    }

}


mysql_close($conn);

?>

please help

[John]

PHP Code:

$_POST['pass']==$choose['cpass'] 


$choose is the query, not the result. $wynik is your result. Even so

PHP Code:

$_POST['pass']==$wynik['cpass'] 


will still return false because $wynik['cpass'] is an array of strings, not a single string, which you are checking for. You can get it to work using a loop or one of the array functions, but in general this is a poor login script.