Welcome Guest, Not a member yet? Register   Sign In
Active Record "get()" with "limit()" and pagination/uri segment value displaying one too few results
#1

[eluser]fiddle-sticks[/eluser]
Hi please can somebody tell me why I am only getting a result of 11 items instead of 12 on the first page (no 3rd uri segment) with the following code.
Code:
$limit = 12;
$offset = $this->uri->segment(3, 0);
$this->db->order_by('created', 'desc');
$this->db->where('is_private !=', '1');
$row = $this->db->get('pictures', $limit, $offset);
Thanks in advance.
Ps Im not sure if posted this in the right place because I couldnt find exactly where this shoul be posted.
Regards


Messages In This Thread
Active Record "get()" with "limit()" and pagination/uri segment value displaying one too few results - by El Forum - 05-16-2011, 03:54 AM



Theme © iAndrew 2016 - Forum software by © MyBB