sql query using redbeans php

Question

Hi I am just beginning to use redbeans ORM. I followed the docs and tried doing a query like this

$thebean=R::find("users","id>2");

and then I loop through like:-

foreach($thebean as $bean){
echo $bean->username;
}

However I find that if the even if the users table contains more than 100 data, the above query only fetches the last data . for eg: if I have users 1 to 100. I only get the user with id=100. Can somebody please tell me what I might be doing wrong.

Answer 1

Seems that it was a problem with the id field. Solved it using tableformatter option.