Mysql Count，If，Else

Question

    {
    $SQL = $odb -> prepare("SELECT `membership` FROM `users` WHERE `ID` = :id");
    $count = $odb->num_rows;
    $SQL -> execute(array(':id' => $_SESSION['ID']));
    if ($count > 0){
        return true;
        } else {
        return false;
    }
}

What am I doing wrong?

The data must be retrieved from the database of User. And if the value of membership is 0, then get Return False deployed. If not, return True. But the script does not work ... What am I doing wrong?

Answer 1

Put $count = $odb->num_rows; below $SQL -> execute(array(':id' => $_SESSION['ID']));