how to get particular products from collection in magento

Question

for example my store has 20 products. I load all products using following code

$collection = Mage::getSingleton('catalog/product')->getCollection()->addAttributeToSelect('*')->addAttributeToSort('name','ASC');

In ascending order they list a product from number 1,2,3,...20.

how i get products which are numbered 8,9,10..15.

Answer 1

Try:

/** @var Mage_Catalog_Model_Resource_Product_Collection $collection */
$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addAttributeToSelect('*')
    ->addAttributeToSort('name','ASC');
$collection->getSelect()->limit(8,7);
$items = $collection->getItems();
echo count($items); // or something else

Answer 2

this will do trick for you

$collection = Mage::getSingleton('catalog/product')->getCollection()->addAttributeToSelect('*')->addAttributeToSort('name','ASC')
$collection->getSelect()->limit(7,8);