How to run magnto outside platform and get product collection query

Posted Date: February 1, 2010

Yesterday I was trying to find out that how to run magento outside platform and found out very nice little code and also how you can get the query of product collection or any other table using the following code:


<?php

getCollection();
$collection->addAttributeToSelect('status');
$collection->addAttributeToSelect('orig_price');

echo $collection->getSelect(); // This line will print the query for the above collection

?>

Hope this code will help someone