[thelist] Odd Behavior last night with MySQL Server

[Rob Smith]

Hi,

Remember the script I told you about yesterday that took a .csv file for
reading, took all the lines out and placed the contents into sql queries:?

$filename = "/..(absolute path)../test.csv";
$handle = fopen($filename, "r");
$contents = explode("\r\n", fread($handle, filesize($filename)));
	
for ($i = 0;$i<count($contents)-1;$i++)
{
  $line = explode(",",stripslashes($contents[$i]));
  mysql_query("INSERT INTO ofnav VALUES
(".$line[0].",".$line[1].",".$line[2].",".$line[3].",".$line[4].",".$line[5]
.")");
}

fclose($handle); 

The contents of the csv are (excerpt):

398,"Home","Books","Cooking","Regional & Ethnic",""
399,"Home","Books","Cooking","Regional & Ethnic","Asian"
400,"Home","Books","Cooking","Regional & Ethnic","Cajun & Creole"
401,"Home","Books","Cooking","Regional & Ethnic","Eastern European"
402,"Home","Books","Cooking","Regional & Ethnic","European"
403,"Home","Books","Cooking","Regional & Ethnic","French"

Ok. There are 2103 rows like this in my csv file. I've (now) confirmed that
5 times. Yet when I run the above script, it will sporadically skip large
amounts of rows?! In one particular case it will go from "429" skips to
"519" and "1444" skips to "1638," when there are in fact normal rows just
like this. Feel free to look at the csv file and see if you see anything
wrong:

http://www.azuritedesign2.com/One-Fourth/test.csv

These are the INSERT commands generated by the above script:

http://www.azuritedesign2.com/One-Fourth/importdata.php

It all looks like it should work right? Then why am I missing 395 rows of
data? in different places? Only 1708 get inserted.

Is there a bug in MySQL?

Rob Smith