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?

does not work is never a good problem description. How is the result you're currently getting different from what you want? Please elaborate. — Amal
– Amal, Commented Oct 14, 2013 at 19:58

Cristian Bitoi · Accepted Answer · 2013-10-14 19:58:24Z

6

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

answered Oct 14, 2013 at 19:58

Cristian Bitoi

1,5571 gold badge10 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql Count, If , Else

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related