login help

[hamza]

Please tell me why this thing is not signin corrctly .

when i enter the correct username and password it works

and if i enter worng one its shows nothing not work.

what is happen in this code tell me .

--------------------------------

$sql = "select *

          from signin

          where user='$_POST[name]' and password='$_POST[password]';

      ";

$res = mysql_query($sql,$con)or die(mysql_error());

//if query is fetched then $var have something in it and it say match.

if(!empty($var))

                          {

echo "match";

                            ::)break;

                          }

                          elseif(empty($var))

 

                          {

echo "not match";

                            }

}

-------------------------------------------------------------------------------

[~n[EO]n~]

Where did that $var come from, it should be like this .. just an example

<?php
$sql = "select * from signin where user='$_POST[name]' and password='$_POST[password]'";
$res = mysql_query($sql,$con)or die(mysql_error());

## where did this var come from... 
## it should be res
      if($res) // if there is result returned from the above query 
      {
       echo "found"; // user found proceed to login
      }
  else
  {
  echo "not found "; // did not match redirect to login page 
  }
                          
?>