title: How to get order increment id using order id?
body: <p>How can I get order increment id (like 100000028) with order id (like 28). In sales order page order increment id is like 100000028, but I have order id like 28.</p>
  
  <p>How can I get order increment id by order id? I have tried below</p>
  
  <pre><code>$write = Mage::getSingleton('core/resource')-&gt;getConnection('core_read');
  $result=$write-&gt;query("SELECT entity_id FROM `sales_flat_order` WHERE `increment_id` = 'your increment id' ");
  $row = $result-&gt;fetch();
  echo $row['entity_id'];
  </code></pre>