title: How to get configurable product price range in magento?
body: <p>I need configure Product price range like</p>
  
  <p><img src="https://i.stack.imgur.com/vb7IE.png" alt="below image is my requirement"></p>
  
  <p>For the product name: $140 - 310 i use below code</p>
  
  <pre><code>if(Mage::getSingleton('customer/session')-&gt;isLoggedIn())
  {
          // Get group Id
          $groupId = Mage::getSingleton('customer/session')-&gt;getCustomerGroupId();
  }
  else
  {
          $groupId = 0;
  }     
  $db = Mage::getSingleton('core/resource')-&gt;getConnection('core_write');
  $result = $db-&gt;query('SELECT price ,final_price, min_price, max_price, tier_price, group_price FROM catalog_product_index_price WHERE entity_id='.$_product-&gt;getId().' AND customer_group_id ='.$groupId.' ORDER BY customer_group_id ASC LIMIT 1');
  $rows = $result-&gt;fetch();
  </code></pre>
  
  <p>i also need a regular price range for the configure product. i also think that my range after product name my be wrong because in <code>Your Price have a price $135</code> so how can i get minimum value and maximum special price and also in regular price?</p>
  
  <p>How can i get that?</p>
  
  <p>Thanks and Regards</p>