States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

States if India not displaying in dropdown list during checkout process in magento 1.7.0.2

INSERT INTO `directory_country_region` VALUES<br /> (NULL , “IN”, “Andaman Nicobar”,”Andaman Nicobar”),<br /> (NULL , “IN”, “Andhra Pradesh”,”Andhra Pradesh”),<br /> (NULL , “IN”, “Arunachal Pradesh”,”Arunachal Pradesh”),<br /> (NULL , “IN”, “Assam”,”Assam”),<br /> (NULL , “IN”, “Bihar”,”Bihar”),<br /> (NULL , “IN”, “Chandigarh”,”Chandigarh”),<br /> (NULL , “IN”, “Chhattisgarh”,”Chhattisgarh”),<br /> (NULL , “IN”, “Dadra Nagar Haveli”,”Dadra Nagar Haveli”),<br /> (NULL , “IN”, “Daman Diu”,”Daman Diu”),<br /> (NULL , “IN”, “Delhi”,”Delhi”),<br /> (NULL , “IN”, “Goa”,”Goa”),<br /> (NULL , “IN”, “Gujarat”,”Gujarat”),<br /> (NULL , “IN”, “Haryana”,”Haryana”),<br /> (NULL , “IN”, “Himachal Pradesh”,”Himachal Pradesh”),<br /> (NULL , “IN”, “Jammu Kashmir”,”Jammu Kashmir”),<br /> (NULL , “IN”, “Jharkhand”,”Jharkhand”),<br /> (NULL , “IN”, “Karnataka”,”Karnataka”),<br /> (NULL , “IN”, “Kerala”,”Kerala”),<br /> (NULL , “IN”, “Lakshadweep”,”Lakshadweep”),<br /> (NULL , “IN”, “Madhya Pradesh”,”Madhya Pradesh”),<br /> (NULL , “IN”, “Maharashtra”,”Maharashtra”),<br /> (NULL , “IN”, “Manipur”,”Manipur”),<br /> (NULL , “IN”, “Meghalaya”,”Meghalaya”),<br /> (NULL , “IN”, “Mizoram”,”Mizoram”),<br /> (NULL , “IN”, “Nagaland”,”Nagaland”),<br /> (NULL , “IN”, “Orissa”,”Orissa”),<br /> (NULL , “IN”, “Pondicherry”,”Pondicherry”),<br /> (NULL , “IN”, “Punjab”,”Punjab”),<br /> (NULL , “IN”, “Rajasthan”,”Rajasthan”),<br /> (NULL , “IN”, “Sikkim”,”Sikkim”),<br /> (NULL , “IN”, “Tamil Nadu”,”Tamil Nadu”),<br /> (NULL , “IN”, “Tripura”,”Tripura”),<br /> (NULL , “IN”, “Uttar Pradesh”,”Uttar Pradesh”),<br /> (NULL , “IN”, “Uttaranchal”,”Uttaranchal”),<br /> (NULL , “IN”, “West Bengal”,”West Bengal”);</p> <p>INSERT INTO `directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT ‘en_US’, tmp.region_id, tmp.default_name FROM `directory_country_region` AS tmp WHERE tmp.country_id=’IN’;<br />

Puneet Kumar Magento Developer