Pagination in search result

[eluser]natefons[/eluser]
in your total rows, use the where clause to filter down the search.

Code:

$paginator_config['total_rows']=$this->db->get_where('records', array('search' => $SEARCH_TERMS));

now for the records, same way, u would use the search term.

"Select * from `records` WHERE `search`='SEARCHTERM' LIMIT '".$limit."','".$offset."';";


at least this is how i did it. (i used sql queries, rather than active records)


not sure if this is the simplest.