insert je vo foreach, cize sa pravidelne opakuje a cele pole udajov sa postupne vklada. takto tusim by sa s tym mohlo dat nieco robit, ci nie?
Kód:
foreach($lines as $line)
{
list($id, $name,$x, $y, $player, $points, $rank) = explode(',', $line);
$name = urldecode($name);
$name = addslashes($name);
$query = "INSERT INTO villages SET id='$id', name='$name', x='$x', y='$y',
player='$player', points='$points', rank='$rank', time='$time'";
$result = $db->query($query);
}
