If you’re operating with magento order and searching for order details you’ll load order in 2 ways that

Get order by Increment Id
Get order by Entity Id

You can use either methodology to load order in magento. we have a tendency to square measure reaching to justify the magento order details with example.

Get order by Entity Id

$order_Id = 111; // this is entity id
$order = Mage::getModel('sales/order')->load($order_Id);

Get order by Increment Id

 $orderIncrement_Id = 1000017; // this is entity id 
$order = Mage::getModel('sales/order')->loadByIncrementId($orderIncrement_Id); 

Get ordered items collection.

$orderItemsCollection = $order->getItemsCollection();
foreach $orderItemsCollection as $item){
$productId = $item->Id();
$productSku = $item->sku();
$productName = $item->getName();
}

Also you can get magento real order id from increment id below is the code.

$orderId = Mage::getModel('sales/order')
->loadByIncrementId($incrementId)
->getEntityId();