zend framework paging

[jim9]

Is there a way to page a database resultset in the zend framework? If so, where do you put all the code to do it?
I am new to frameworks but not to php. I checked the manual and couldn't find anything about paging records.

[santouras]

I would use something like this

//create Zend_Db_Select instance
$select = $db->select();

//add in our where conditions, this is obviously more then one line
$select->where('conditions');

//clone our conditions
$select2 = clone $select;

//we only want back the total number
$select2->from('table', array('totalrows' => 'COUNT(*)'));

//now we know how many records in total
$totalrows = $db->fetchOne($select2);

//with our original select, we can use paging
$select->from('table')
->limit($start, $end);

$rows = $db->fetchAll($select); 

[jim9]

I am new to frameworks, where would this code be placed?
For example I took the zend tutorial where you have:

id | artist | title.

With the existing application all working, where would this paging code go?
Thanks

[santouras]

it would probably be best to have a read through how to use the Zend Framework first. I found this to be a good read

http://naneau.nl/2007/04/21/a-zend-f...rial-part-one/