Zasílám a díky za každou radu.
code/php
<?
include("../../config.php");
$link = mysqli_connect(_DB_SERVER_,_DB_USER_,_DB_PASSWD_,_ DB_NAME_);
mysqli_query($link, " SET NAMES 'utf8' ");
mysqli_query($link, " SET CHARACTER SET charset_name 'utf8' ");
$map = file("../files/file.csv");
$i = 0;
while ($axe = $map[$i])
{
$se[$i] = explode(";", $map[$i]);
echo $query = "UPDATE prod SET `prix`='".$se[$i][1]."' WHERE `reference`='".$se[$i][0]."'";
printf(" vysledek: %d\n", mysqli_affected_rows($link));
echo "<br>";
mysqli_query($link, $query);
$i++;
}
mysqli_close($link);
?>
code/php