unable to count number of rows

[narjis]

I am using mysqli to open the database table and execute query. The qery is running successfully, but the number of rows count is not giving correct results.

$username=$_POST['username'];
    $pass=$_POST['password'];
    $mysql = mysqli_connect("localhost","root","","auth");
    $sql="SELECT * FROM 'authorized_users' WHERE name = '".$username ."' AND password  = '"
    . $pass. "'"; 
   // print "$username $password";
    if(!$mysql){echo "cannot connect to databse" ;
    }
    else
    {
    echo "Connected";
    $result = $mysql->query($sql);

    $row = $result->num_rows;
    echo "Found \$rows ". $row;
    for($i=0;$i<$row;$i++){
    echo "found a record at ".$i;
    } 
    $result->close();
    } 
    $mysql->close();  

This should return 3 rows but it gives 1 only.

[gristoi]

So, do you have three rows in your table with identical username and password ?

[narjis]

no

[gristoi]

You query is looking for records where the usename and password match the ones passed into it, so if you only have one record where the username and password match you will only return 1 row.

 

Why were you expecting 3 rows to be returned?