Try the following:
$attribute_option_id = Mage::getResourceModel('catalog/product')->getAttributeRawValue($productId, 'my_attribute', $storeId); $product = Mage::getModel('catalog/product') ->setStoreId($storeId) ->setData('my_attribute', $attribute_option_id); $text = $product->getAttributeText('my_attribute');
OR
$_id = $this->getProduct()->getId(); $_resource = Mage::getSingleton('catalog/product')->getResource(); $optionValue = $_resource->getAttributeRawValue($_id, [ATTRIBUTE_ID/ATTRIBUTE_CODE], Mage::app()->getStore()); echo $optionValue;
OR
$attribute_value = $product->getResource()->getAttribute($attribute_code)->getFrontend()->getValue($product);
Greetings :-)
source share