alexa

<?php
ini_set("display_errors",1);
error_reporting(E_ALL);
include ('../inc/conf.php'); // Connect db

$q=mysql_query('SELECT * FROM `domain`');
while($post=mysql_fetch_assoc($q)){
//domain list
$id = htmlspecialchars(abs(intval($post['id'])));
$domain_name = htmlspecialchars($post['domain_name']);


$alexa = simplexml_load_file("http://data.alexa.com/data?cli=10&dat=snbamz&url=$domain_name");
//$localrank = $alexa->SD[1]->COUNTRY["RANK"];
$globalrank = $alexa->SD[1]->POPULARITY["TEXT"];

mysql_query("UPDATE `domain`  SET `alexa_rank`='$globalrank' WHERE `domain_name`='$domain_name'");

//echo "$id </br>";
}
?>