Select last 5 records from each user

Select last 5 records from each user - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Select last 5 records from each user (/showthread.php?tid=49331)

Select last 5 records from each user - El Forum - 02-15-2012

[eluser]trinic[/eluser]
nvrmind...

fixed

Select last 5 records from each user - El Forum - 02-15-2012

[eluser]troy_mccormick[/eluser]
Not knowing your db schema, but I'm going to guess something like this:

Code:
&lt;?php

$query = $this->db

    ->select('id, page_title')

    ->where('nav_id', 12)

    ->order_by('some_field', 'DESC')

    ->limit(5)

    ->get('pages');

?&gt;