[Resolved] inserting data into MySQL

[Dillenger]

Ok, so I got the function to read out a csv file, but how do i then put the values into a MySQL database?

<? 
$row = 1;
$handle = fopen("/home/yellow1/public_html/database/admin/input/temp/SEIZURE.txt", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $num = count($data);
   echo "<p> $num fields in line $row: <br /></p>\n";
   $row++;
   for ($c=0; $c < $num; $c++) {
       echo $data[$c] . "<br />\n";
   }
}
fclose($handle);
?>

[Dillenger]

Nevermind, I figured it out by myself, here is the code, incase anyone is interested:

<? 
$row = 1;
$handle = fopen("file.txt", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $num = count($data);
   $row++;

   $SQL = " INSERT INTO emp_standards (field1, field2, field3, field4, field5, field6, field7) VALUES ('$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]', '$data[5]', '$data[6]', '$data[7]')";
	   $result = mysql_db_query($db,"$SQL",$connect);
			if (!$result) {
		echo("ERROR: " . mysql_error() . "\n$SQL\n");
		  }
}
fclose($handle);
?>