PHP/mySQL Login Page HELP!

Anon

I am currently trying to build a PHP page that validates a username and password from a form against values stored in a mySQL database and them redirects based on success or failure.

Below you will find the code, my problem is $result returns "Resource id #2". Haven't a clue as to what is going on...

$db = mysql_connect($host, $user, $pass)

mysql_select_db($db_name,$db);

$sql = select username, password from users where username='$form_username' and password='$form_password'";

$result = mysql_query($sql);

if ($result){
header ("location: success.php");
}else{
header ("location: faliure.php");
}

Anon

If $result is positive then the query was valid and ran properly. Note that this doesn't mean that it found any entries. Zero matches is a perfectly acceptable result. What you should do is

if (mysql_num_rows($resut) > 0) {
OK!
} else {
NO
}

BTW: You should describe what should happen and what is actually happening.

Anon

Thanks Ken, working now!

Anon

Im trying to create a login using php and my sql. When i test the login, the page goes blank irrespective of what username or password i have entered.<?
if ($username=='' && $password==''){
Header("Location:index.php");
exit;}

else {

if($username !=''){
$connection=@mysql_connect("localhost","online1","cool") or die ("Unable to make connection");
mysql_select_db("rci") or die ("couldn't selcet database");
$sql = "SELECT * FROM login where user= '$PHP_AUTH_USR' and passwd='$PHP_AUTH_PASS'";
$result = mysql_query($sql) or die ("Unable to
execute sql $sql");
$num = mysql_numrows($result);

                    if ($num != "0") {
                    echo "<P>You're authorized!</p>";
                    exit;}
                    else    {
                    echo "try again";
                    }
                    }
    }

Ken wrote:

If $result is positive then the query was valid and ran properly. Note that this doesn't mean that it found any entries. Zero matches is a perfectly acceptable result. What you should do is

if (mysql_num_rows($resut) > 0) {
OK!
} else {
NO
}

BTW: You should describe what should happen and what is actually happening.