Ciao Ragazzi,

non riesco a capire dove sbaglio quando tento di fare il login mi da un messaggio di warning e non procede al login, mi sapreste dire dove sbaglio gentilmente! Grazie.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\hb9fax.ch.new\admin\login.php on line 29

Codice PHP:

<?php require_once('../Connections/hb9faxdb.php');?>
<?php 

// Avvio la Sessione

session_start();

// Verifico se submit e definito

if (isset($_POST['Submit'])) {

// Definisco le variabili $Username, $Password, $LoginOk

$Username = $_POST['usr'];
$Password = $_POST['pwd'];
$LoginOk = "admin.php";

// Query per verificare il login su database

$query = "SELECT * FROM tb_users WHERE usr_username='$Username' AND usr_password=md5('$Password')";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0) {            --- l'errore e su questa riga ----

// Metto in sessione il nome utente e la password
 $_SESSION['UserName'] = $Username;
 $_SESSION['Password'] = $Password;

// Reindirizzo alla pagina admin.php se il login é corretto
 header("Location: $LoginOk");

// Chiudo lo script in caso che la condizione sia vera
 
 exit();

}
else

// Messaggio di errore in caso di login errato
 $msg = "<span class=\"errorLoginRed\">Password o nome utente errati!\n</span>";
}

?>
<head>
<link href="css/master.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><form name="form1" method="post" action="<?php $_SERVER['PHP_SELF'];?>">
      <table width="300" border="0" cellpadding="0" cellspacing="0" bordercolor="#990000">
        <tr>
          <td height="30" colspan="2"><div align="center" class="testo">Area Login: </div></td>
        </tr>
        <tr>
         <td height="30" colspan="2"><div align="center"><?php echo $msg ;?>
         </div></td>
        </tr>
        <tr>
          <td width="150" height="30"><div align="center" class="testo">Username :</div></td>
          <td width="150" height="30">
            <div align="left">
              <input name="usr" type="text" class="boxins" id="usr">
              </div></td>
        </tr>
        <tr>
          <td height="30"><div align="center" class="testo">Password :</div></td>
          <td height="30">
            <div align="left">
              <input name="pwd" type="password" class="boxins" id="pwd">
              </div></td>
        </tr>
        <tr>
          <td height="30"></td>
          <td height="30">
            <div align="left">
              <input name="Submit" type="submit" class="boxins" value="Login">
              </div></td>
        </tr>
      </table>
        </form>
    </td>
  </tr>
</table>


</body>
</html>