I want to load data from a table using collection and I need the result to be in the ascending order of the 'sort_order' column which is an integer value.
The above pic shows the columns in admin form.
The above pic is of the database table.
This is the code which I used to retrieve the collection.
$collection = Mage::getModel('hm_faq/object')->getCollection()->addFieldToFilter('category_id',$category->getId());
$collection->setPageSize(5);
$collection->setCurPage(2);
$size = $collection->getSize();
$cnt = count($collection);
foreach ($collection as $button) {
$i = $i+1;
?>
<a id="<?php echo $button->getUrlId(); ?>" href="<?php echo $button->getUrlLink(); ?>" >
<div class="faq-white-button">
<div class="faq-inner">
<h3 class="faq-button-label"><?php echo $button->getUrlLabel(); ?></h3><span class="faq-icon">></span>
</div>
</div>
</a>
<?php echo '<br>';} ?>
How can i arrange the result in the ascending order of the sort_order?
Best Answer
Try with this: