External Urls In Magento

Collected from a blog:

 

Which solves your problem :)

Create a root file with name of your choice and apply the following code.
require_once “app/Mage.php”;
Mage::app(‘default’);
$sql = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’);
$result = $sql->query(“Required Query”);
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
//echo $row[''].”<br />”;
// fetch records
}