"; $con = mysql_connect("localhost", "root", "root"); mysql_select_db("kladr1", $con); $f = fopen("Regions.csv", "r"); while(!feof($f)) { $region = fgetcsv($f, 1000, ';'); $query1 = mysql_query("SELECT * FROM kladr".$region[0].";"); for($i = 1; $i <= mysql_num_rows($query1); $i++){ $obj = mysql_fetch_object($query1); $data[$obj->parentcode]++; } $query1 = mysql_query("SELECT * FROM kladr".$region[0].";"); for($i = 1; $i <= mysql_num_rows($query1); $i++){ $obj = mysql_fetch_object($query1); $query3 = mysql_query("UPDATE kladr".$region[0]." SET numchildre = {$data[$obj->code]} WHERE code = '{$obj->code}';"); } unset($data); } echo date("H:i:s"); ?>