Limit results collection in Magento

<?php
$limit = 5;
$starting_from = 2;
$product_collection = Mage::getModel('catalog/product')->getCollection()->setOrder('name', 'asc'); //getting the product collection, results are ordered by product name
$product_collection->getSelect()->limit($limit,$starting_from);	//where	$limit will be the number of results we want, $starting_from will be the index of the result set to be considered as starting point (note 0 is the index of first row)
//this will ouptput 5 records starting from 3rd record
foreach($product_collection as $_product)
{
	echo $_product->getName().'<br/>'; 
}
?>

Suppose the first 10 products (ordered by name) are

A
B
C
D
E
F
G
H
I
J

The above foreach will output

C
D
E
F
G

10 thoughts on “Limit results collection in Magento”

1. Thank you very much! it is really useful.
   I like getSelect in magento to query data base!

2. You can also use setPageSize() for setting page limit in product collection..

   1. But you cannot, specify the sets meaning I want 5 results starting from record 11, etc.

3. Really this post was useful. Thank you!1

   1. I am glad it was helpful

4. i want to limit related product, up-sell product, featured product limit.
   i

   1. You can use the functions as described in the post, on any collections

5. Hi, can you please reply me how to put limit for custome table collection.

   1. @prasad – You can use above mentioned code on custom collection also.

6. Thank you
   Very beautiful

Comments are closed.