getting previous, current, and next data from database

Not tested but I believe it works like this.

PHP Code:

$query = $db->query("YOUR QUERY");

$row = $query->getRowArray();

$row = $query->getFirstRow($row)
$row = $query->getLastRow($row)
$row = $query->getNextRow($row)
$row = $query->getPreviousRow($row) 


Give that a try.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )