How to get order increment id using order id?
increment, magento
Solution
$order = Mage::getModel('sales/order')->load($orderid);
$Incrementid = $order->getIncrementId();
Problem
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. How can I get order increment id by order id? I have tried below ``` $write = Mage::getSingleton('core/resource')->getConnection('core_read'); $result=$write->query("SELECT entity_id FROM `sales_flat_order` WHERE `increment_id` = 'your increment id' "); $row = $result->fetch(); echo $row['entity_id']; ```