Select last 5 records from each user

Select last 5 records from each user

El Forum
Guest

02-15-2012, 05:19 PM

[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;

Messages In This Thread

Select last 5 records from each user - by El Forum - 02-15-2012, 05:13 PM

Select last 5 records from each user - by El Forum - 02-15-2012, 05:19 PM