Skip to main content

Mysql query how to use if condition?

inside mysql query add this

  SELECT  IF( viewers > 100 , 1, 0) AS hotproduct FROM mytable
the condition is like this


IF ( condition here , true , false )

Comments

Post a Comment

Popular posts from this blog

How to add tab in Customer Information in Magento Admin

Step 1) Override the file /app/code/core/Mage/Adminhtml/Block/Customer/Edit/Tabs.php, Inside _beforeToHtml() method, add the following code: $ this -> addTab ( 'Custom' , array (      'label'   = > Mage :: helper ( 'customer' ) -> __ ( 'Custom' ) ,      'class'   = >     'ajax' ,      'url'     = >     $ this -> getUrl ( '*/*/custom' , array ( '_current' = > true ) ) , ) ) ; Step 2)  Override the file /app/code/core/Mage/Adminhtml/controllers/CustomerController.php, Add the following code: public function customAction() { $this->_initCustomer(); $this->getResponse()->setBody( Mage::app()->getLayout()->createBlock('core/template')->setTemplate('custom/customer/tab/custom.phtml')->setCustomerId(Mage::registry('current_customer')->getId())         ->setUseAjax(true)-...
Post a Comment
Read more

get directory paths, get Base URLs, get URLs in static block, get secure URL in Magento

1) Get Directory paths  Mage::getBaseDir()  //output : /var/www/html/magento Mage::getBaseDir('app')  //output : /var/www/html/magento/app Mage::getBaseDir('media') //output : /var/www/html/magento/media Mage::getBaseDir(‘design’) => Get design directory path Mage::getBaseDir(‘code’) => Gives code directory file path Mage::getBaseDir(‘lib’) => Gives lib directory file path Mage::getBaseDir(‘skin’) => Gives skin directory file path Mage::getBaseDir(‘var’) => Gives var directory file path Mage::getBaseDir(‘cache’) => Gives cache directory file path Mage::getBaseDir(‘log’) => Gives log directory file path       2) Get Base URL  Mage::getBaseUrl() => Get base url path e.g. http://yourwebsite.com/  Mage::getBaseUrl('media') => Get MEDIA folder path e.g. http://yourwebsite.com/media/  Mage::getBaseUrl('js') => Get JS folder path e.g. http://yourwebsite.com/js/  Mage::getBaseUrl('skin') => Get...
1 comment
Read more

change precision of price in magento

By default Magento show price with two decimal points like Rs. 25.00 , if you want to change the precision of  Price then  In line 62 in /lib/zend/Currency.php you can change the precision for all  prices in your shop. <?php protected $_options = array( 'position' => self::STANDARD, // position for the currency sign 'script' => null, // script for output 'format' => null, // locale for numeric output 'display' => self::NO_SYMBOL, // currency detail to show 'precision' => 0, // precision for currency 'name' => null, // name for this currency 'currency' => null, // 3 lettered international abbreviation 'symbol' => null // currency symbol ); and /app/code/core/Mage/Core/Model/Store.php Change the roundPrice function to: public function r...
Post a Comment
Read more