How to get attribute_id from “eav_attribute” table in Magento [duplicate]

Question

I need to get attribute_id from eav_attribute table, I have attribute_code and frontend_label, my sql query will be some thing like this.

select attribute_id from eav_attribute where attribute_code = 'sb_store_id'

What will be its equivalent magento statement.

Answer 1

you can get id from attribute code like that

$attribute_code = "sb_store_id"; 
$attribute_details =
Mage::getSingleton("eav/config")->getAttribute('catalog_product',    $attribute_code);

echo $attribute_details->getAttributeId(); //marius suggestion

Answer 2

Here is how you should do it.

You need to know the entity type to be able to get it (product,category...).

Example for product:

$attribute = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY , 'sb_store_id');