title: PHP MySQL query output
body: <p>I am trying to do a query in which i can see if username and password can match. If it matches, then I will go to the administrator pages. The problem Im having is that i think that the query is not giving me the right results. The database table is called admin, and it has adminame and passadmin. The user im entering IS in the database. The password is encrypted. </p>
  
  <pre><code>&lt;?php
  
      $f_user = $_POST['f_user'];
      $f_pass = $_POST['f_pass'];
  
      $status = authenticate($f_user, $f_pass);
  
      if ($status == 1)
      {
          include("../connections/config.php");
  
          session_start();
          //session_register("SESSION_UNAME");
          $_SESSION['SESSION_UNAME'] = $f_user;
          $SESSION_UNAME = $f_user;
          header("Location: unoadmin.php");
          exit();
      }
      else
      {
          $mensa= "Informaci&amp;oacute;n Incorrecta...Int&amp;eacute;ntelo de Nuevo";
          header("Location: register.php?mensa=$mensa");
          exit();
      }
  
      function authenticate($user, $pass)
      {
          include("../connections/config.php");
  
          $connection = mysql_connect($mach,$userna,$paso) or die ("Unable to connect!");
          $query = "SELECT * from admin WHERE adminame = '$f_user'";
          mysql_select_db($db);
          $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
          $num_results = mysql_num_rows($result);
  
          if ($num_results == 1)
          {
              for($i=0; $i &lt; $num_results; $i++)
              {
                  $row = mysql_fetch_array($result);
                  $pas = $row["passadmin"];
              }
              if(crypt($pass,$pas) == $pas)
              {
                  return 1;
              }
              else
              {
                  return 0;
              }
          }
          else
          {
              return 0;
          }
      }
  ?&gt;
  </code></pre>
  
  <p>Can someone tell me what is the error? It is leading me to "Información incorrecta. Intentelo de nuevo" or in english "Wrong information. Try again"</p>