function update_records ($id,$reseller,$server_hostname) {
$reseller_data = curl_reseller_data($id,$reseller,$server_hostname);
$diskusage = $reseller_data[1];
$disklimit = $reseller_data[2];
$bwusage = $reseller_data[3];
$bwlimit = $reseller_data[4];
$update = "UPDATE `tblhosting` SET diskusage='".$diskusage."', SET disklimit='".$disklimit."', bwusage='".$bwusage."', bwlimit='".$bwlimit."' WHERE username='".$reseller."'";
mysql_query($update) or die(mysql_error());
}
require "dbconnect.php";
// Make a MySQL Connection
$query = "SELECT server,username FROM `tblhosting` WHERE packageid IN (SELECT id FROM `tblproducts` WHERE type= 'reselleraccount')";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$id = $row['server'];
$server_hostname = get_server_name ($id);
$reseller = $row['username'];
update_records($id,$reseller,$server_hostname);
echo $id.'
';
echo $server_hostname.'
';
echo $reseller.'
';
}