repeat problem

[Olof Glans]

Hi! This repeat only gives me 1 entry from database, though I know it should have atleast 3.

Controller:

$comments = new DB\SQL\Mapper($db,'comments');

$comments->load();

$f3->set('comments', $comments);

echo \Template::instance()->render('views/home/home.php');

View (home.php):

<repeat group="{{ @comments }}" value="{{ @comment }}">

    <p>{{ trim(@comment) }}</p>

</repeat>

When I ask for the number of affected rows for the query it says 2, and my database says 2 too.

[xfra35]

load() is for record-by-record navigation. Try find().

Cf. https://fatfreeframework.com/3.6/databases#SeekandYouShallFind