Category Archives: Uncategorized

dffddfdfdffd

dfdfdffd Advertisements

Posted in Uncategorized | Leave a comment

How to delete a value to a field separated by comma

“update “.FOLLOWING_FOLLOWERS.” set board_id= TRIM(BOTH ‘,’ FROM REPLACE(CONCAT(‘,’, board_id, ‘,’), ‘,$board_id,’, ‘,’)),`follow_on`=’”.$this->currentdate.”‘ where user_id=$userid and following_follower_id=$following_follower_id and type=’”.FOLLOWING.”‘ and status=’”.FOLLOW.”‘”;

Posted in Uncategorized | Leave a comment

how to add a extra value to a field separated by comma in mysql

$concat_id=’,’.$board_id; $sql=”update “.FOLLOWING_FOLLOWERS.” set board_id=concat(board_id, ‘$concat_id’),`follow_on`=’”.$this->currentdate.”‘ where user_id=$userid and following_follower_id=$following_follower_id and type=’”.FOLLOWING.”‘ and status=’”.FOLLOW.”‘”;

Posted in Uncategorized | Leave a comment

How to get count from each filed contain separated commas using mysql

“SELECT GROUP_CONCAT( DISTINCT `board_id` ) , ( CHAR_LENGTH( GROUP_CONCAT( DISTINCT `board_id` ) ) – CHAR_LENGTH( REPLACE( GROUP_CONCAT( DISTINCT `board_id` ) , ‘,’, ” ) ) +1 ) AS totalcount FROM “.FOLLOWING_FOLLOWERS.” AS B WHERE B.status = ‘”.FOLLOW.”‘ AND B.type = … Continue reading

Posted in Uncategorized | Leave a comment

To changes 2 files

frontend\base\default\template\checkout/cart.phtml and frontend\base\default\template\checkout/cart/shipping.phtml

Posted in Uncategorized | Leave a comment

add 2 add to cart button

Please refer website: http://phprelated.myworks.ro/two-add-to-cart-buttons-with-different-redirect-actions-at-once-in-magnto/

Posted in Uncategorized | Leave a comment

How to Get Add to cart button url in Magento

From the following code you can get direct link to add cart button <input type=”button” title=”__(‘Add to Cart’) ?>” onclick=”setLocation(‘$row[‘product_id’],’qty’=>1)) ?>’)” />

Posted in Uncategorized | Leave a comment

To select values from mysql in magento:

To enter this code: $readonce = Mage::getSingleton(‘core/resource’)->getConnection(‘core_read’); $rows = $readonce->fetchAll(‘SELECT * FROM catalog_product_entity_int where attribute_id =’.$attribId); foreach ($rows as $row) { $ops[] = array($row[‘entity_id’], $this->getOptionLabel($row[‘value’]).’ ‘.$this->getOptionValue($row[‘value’])); } return $ops;

Posted in Uncategorized | Leave a comment

how to add cufon js to magento without conflict other js

Refer Site is:http://networkedblogs.com/cm3Htand codings:Implement Cufon fonts in Magento StoreCufon is basically a javascript text replacement technique which takes the font, renders every character with its information like color, size, etc and replaces original text.Here we are going to see how … Continue reading

Posted in Uncategorized | Leave a comment

how to add a slideshow in magento

  To refer this site http://pravams.com/2010/12/23/add-banner-slidehsow-to-magento/

Posted in Uncategorized | Leave a comment