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); ?>