dffddfdfdffd

dffddfdfdffd

dfdfdffd

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 = ‘”.FOLLOWING.”‘
AND user_id =”.$userid;

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 to implement the cufon fonts in magento by the following steps:First, Go to http://cufon.shoqolate.com/generate/ and upload your font with the instructionsMake sure the “EULAs of these fonts allow Web Embedding” check box should be enabled and get your font name.js file by agree the terms and conditions.Download the basic javascript file – cufon.js ( which is easily available).Upload the js files in public_html/js/cufon/ folder on your server.Add the below code in page.xml file of your theme and place this code inside your head sectionCode<action method=”addJs”><script>cufon/cufon.js</script> </action> <action method=”addJs”><script>cufon/IM_FELL_Double_Pica_PRO_italic_400.font.js</script></action>Add the below code in the head.phtml file of your theme and place this code right before the end of the file.Code<script type=”text/javascript”>Cufon.replace(‘h1’);</script>This code will replace the text inside the h1 tag with custom cufon font. You can target specific classes too if you need it, like this:Eg:Code<script type=”text/javascript”>Cufon.replace(‘.page-title h1, .page-title h2’);</script>
//

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