magentoOrders

Get order by ID

$orderid = 12345;
$order = Mage::getModel('sales/order')->load($orderid);

The above code is roughly analogous to the following SQL query.

select * from sales_flat_order where entity_id=12345;

Get order by Increment ID

$incrementid = 100000000;
$order = Mage::getModel('sales/order')->loadByIncrementId($incrementid);

The above code is roughly analogous to the following SQL query.

select * from sales_flat_order where increment_id=100000000;

The increment_id is the customer facing order identifier, whereas the entity_id is the database level identifier for the order.

Add comment to order history

You can add comment and status to order. Get order :

$orderid = 12345;
$order = Mage::getModel('sales/order')->load($orderid);

And add comment:

//$isNotify means you want to notify customer or not.

$order->addStatusToHistory($status, $message, $isNotify);
$order->save()