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.'

'; }