Magento: Creating custom attribute using sql setup in custom module

/* Magento: Creating custom attribute using sql setup in custom module */

Here I am going show how to create a simple product attribute programatically.I have created a simple script which is creating the product attribute when I do install my module or upgrade my module.So please look at the below code which I have created.

Magento : Get Available Attribute Set Id's And Names From External Script

According to the requirements of your's I have built the external script which will give all the attribute sets which are available under admin => manage attribute sets section . So please check the below coding.

I have placed this script in dir \magento\getAttributeSet.php means in root directory of magento installation folder.

Magento: Speedy Attribute Updates

Generally for updating our attribute value in admin we do like :

Magento : Get Attribute Set Name And Category Name By Product Id

Please follow the below code How to get attribute set name and Product's category name :

Magento: Use Mysql Functions With Addexpressionattributetoselect

Function addExpressionAttributeToSelect as defined in Mage_Eav_Model_Entity_Collection_Abstract (/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php) allows us to use MySQL functions in Magento collection. Here is an example of using MYSQL IN() clause in magenot more product collection at once :