[SOLVED] Catchable fatal error: Object of class mysqli_result could not be converted to s

[cluce 0]

can someone tell me how to get rid of this error.......

 

Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\wamp\www\fail.php on line 21

 

here is my code.........

<?php

$mysqli = mysqli_connect("localhost", "root", "", "test");

$sql = ("SELECT failed_logins FROM auth_users WHERE username = 'me'");
$attempts = mysqli_query($mysqli, $sql);

//disables user
if ($attempts >= 3){
echo ("login disabled");

} else {
    echo ("its good");
echo ("$attempts");
}
?>

 

when I ran this I got his...

its good

Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\wamp\www\fail.php on line 21

 

[chigley 0]

<?php

$mysqli = mysqli_connect("localhost", "root", "", "test");

$sql = ("SELECT failed_logins FROM auth_users WHERE username = 'me'");
$result = mysqli_query($mysqli, $sql);
$resultarr = mysqli_fetch_assoc($result);
$attempts = $resultarr["failed_logins"];

//disables user
if ($attempts >= 3){
echo ("login disabled");

} else {
    echo ("its good");
echo ("$attempts");
}
?>