$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;
