无法从SQL查询中获取COUNT结果

Question

When I run this code it only ever returns 0, even when I have the right information. I have checked in the database the same query and it returns a count of one when I have the correct info but this always returns 0.

$query = 'SELECT COUNT(*) FROM user WHERE UserName = "$username"  AND UserPass = "$password"';

    $result = mysqli_query($con, $query);

    $hello = mysqli_fetch_array($result); echo $hello[0]; exit;

Answer 1

change to

 $query = 'SELECT COUNT(*) FROM user WHERE UserName = "' . $username . '" AND UserPass = "'. $password .'"';