http://inchoo.net/ecommerce/magento/creating-cron-script-in-magento/
http://fishpig.co.uk/magento-tutorials/magento-cron-jobs
http://fishpig.co.uk/magento-tutorials/magento-cron-jobs
A blog that caters the needs as Magento Tutorial for Magento freshers. One can find helps related to Magento issues. Many Magento Extensions and Magento Modules are discussed in this blog. The blog author has himself developed many Magento extensions and has experience of 40+ Magento websites.
$collection = Mage::getModel('catalog/product')->getCollection();
$collection->addAttributeToSelect('name');
$collection->addAttributeToSelect('orig_price');
//filter for products whose orig_price is greater than (gt) 100
$collection->addFieldToFilter(array(
array('attribute'=>'orig_price','gt'=>'100'),
));
//AND filter for products whose orig_price is greater than (lt) 130
$collection->addFieldToFilter(array(
array('attribute'=>'orig_price','lt'=>'130'),
));