Problems with querys

[eluser]James Gifford[/eluser]
Oh, I overlooked something critical!

In your example query, you're getting a result that only has one row. So no matter how many times you call next_row and previous_row you'll always get the same row.

You'll need to change your query so that it returns more than one row. Something like:

Code:

$this->db->where(’id >=’, $id - 1)->where(’id <=’, $id + 1);
$query = $this->db->get(’entries’);