0

i have this code

        //10 = Retail attribute
        $attributesToSelect = array('capacity','sku');
        $productCollection = Mage::getModel('catalog/product')->getCollection();
        $productCollection->addAttributeToSelect($attributesToSelect, 'left')
            ->addAttributeToFilter('modelnumber', $modelnumber)
            ->addAttributeToFilter('attribute_set_id', '10')
            ->joinField(
                'qty',
                'cataloginventory/stock_item',
                'qty',
                'product_id=entity_id',
                '{{table}}.stock_id=1',
                'left'
            )
            ->joinField(
                'value',
                'eav_attribute_option_value',
                'value',
                'option_id=78',
                '{{table}}.stock_id=1',
                'left'
            )
            ->getFirstItem();

        echo"<pre>";
        var_dump($productCollection->getData());
        exit;

how can i get data from table, eav_attribute_option_value where option_id = 78

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.