Magento Add "addAttributeToFilter() function" with Conditionals.

1) Equals: eq

 $_products->addAttributeToFilter('status', array('eq' => 1));

 2) Not Equals - neq

 $_products->addAttributeToFilter('sku', array('neq' => 'test-product'));

 3) Like - like

 $_products->addAttributeToFilter('sku', array('like' => 'UX%'));

 4) Not Like - nlike

 $_products->addAttributeToFilter('sku', array('nlike' => 'err-prod%'));

 5) In - in

 $_products->addAttributeToFilter('id', array('in' => array(1,4,98)));

 6) Not In - nin

 $_products->addAttributeToFilter('id', array('nin' => array(1,4,98)));

 7) NULL - null

 $_products->addAttributeToFilter('description', 'null');

 8) Not NULL - notnull

 $_products->addAttributeToFilter('description', 'notnull');

 9) Greater Than - gt

 $_products->addAttributeToFilter('id', array('gt' => 5));

 10) Less Than - lt

 $_products->addAttributeToFilter('id', array('lt' => 5));

 11) Greater Than or Equals To- gteq

 $_products->addAttributeToFilter('id', array('gteq' => 5));

 12) Less Than or Equals To - lteq

 $_products->addAttributeToFilter('id', array('lteq' => 5));

Magento Arrange Collection in Specific Range Like A-D, 0-9 etc.

Add this code after any collection.

<?php $collection_AtoD->getSelect()->where("name like 'A%' or name like 'B%' or name  like 'C%' or name  like 'D%'"); ?>

Magento Show Discount in Special Price.

Add this code in template > catalog > product > price.phtml

<?php if($_finalPrice < $_price): ?>    
<?php $_savePercent = 100 - round(($_finalPrice / $_price) * 100); $_saveAmount = number_format(($_price - $_finalPrice), 2); ?>        
<p class="yousave">           
    <span class="price-label label">You Save: </span>           
    <span class="price">
        <strong class="save-amount">$<?php echo $_saveAmount; ?></strong> (<?php echo $_savePercent; ?>%)
    </span>
</p>   
<?php endif; ?>