0) $insert .= ",";
$insert .= $headerrow[$c];
}
$query = "TRUNCATE TABLE eqspells;";
mysql_query($query);
while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) {
$num = count($data);
# echo "
$num fields in line $row:
\n";
$row++;
$values = "";
for ($c=0; $c < $num; $c++) {
if ($c > 0) $values .= ",";
$values .= "\"".mysql_real_escape_string($data[$c])."\"";
}
$query = "INSERT INTO eqspells (".$insert.") VALUES(".$values.");";
//echo $query;
mysql_query($query);
}
fclose($handle);
?>