Counting rows warning expected 1 boolean given

Question

$query = "SELECT * FROM tbl_usuarios WHERE email = 'teste@teste.com' and senha = '123456'";
$res=mysql_query($query);
$number=mysql_num_rows($res);

WARNING : mysql_num_rows expects parameter 1 to be resource boolean given i have no ideia why its giving me error

Like @JohnConde said, you can find out more about your error with mysql_error and mysql_errno. Also look into using mysqli instead of mysql, OO way if possible. — fejese, Apr 01 '14 at 13:21
Problem is i tryed out the query on phpmyadmin and worked just fine , i cant figure it out — Tony Santos, Apr 01 '14 at 13:22

score 1 · Accepted Answer · answered Apr 01 '14 at 13:24

it may be the connection error

try

<?php
$con = mysqli_connect('localhost', 'username', 'password','database');
$query= "SELECT * FROM tbl_usuarios WHERE email = 'teste@teste.com' and senha = '123456'";
$res = mysqli_query($con, $query) or die(mysqli_error($con));
while($return_row = mysqli_fetch_array($res, MYSQLI_ASSOC)){
        $name = $return_row['name'];    
}

?>

Counting rows warning expected 1 boolean given

1 Answers1