[RESOLVED] CSV Import to MySQL via PHP

[SFDonovan]

I have a csv file:

1,000077193 ,"ABOUSOUD, OMAR ",9,90,35,9,90
1,000390918 ,"ABRAHAM, HEIDI ",9,90,35,9,90
1,000385334 ,"ADAMSHARRISON, ANGELA ",8,80,14,8,80
1,000545516 ,"AGIN, ANNIE ",8,80,14,8,80
1,000388419 ,"AMPONSAH, EUGEN ",10,100,75,10,100
1,000553939 ,"ANKROM, SEAN T",8,80,14,8,80
1,000034194 ,"BALCIK, BRENDE ",9,90,35,9,90
1,000065368 ,"BARNES, NATHAN ",10,100,75,10,100
1,000345478 ,"BARTON, LUCAS ",10,100,75,10,100

And trying to import it with the following:

if(!defined('TL_ADMIN')) { die("Illegal Access Detected!!!"); }
$modname = "Team_Learning";
include("header.php");
TLAdminMenu();
global $admin_file, $db, $prefix;
$table_name = "_tl_session_grade_import";

if(isset($_POST["Go"]) && ""!=$_POST["Go"]) //form was submitted
{
$file_name = $HTTP_POST_FILES['file_source']['tmp_name'];	  	

$emptytable = "TRUNCATE TABLE ".$prefix."$table_name";
$emptyresult = $db->sql_query($emptytable);

$sql = "LOAD DATA LOCAL INFILE '".mysql_real_escape_string($file_name)."'
	 INTO TABLE ".$prefix."$table_name 
	 FIELDS TERMINATED BY ','
	 OPTIONALLY ENCLOSED BY '\"' 
	 LINES TERMINATED BY '\r\n'"; 
if (!$sql) {echo("<p>Error performing query: " . mysql_error() . "</p>");}
	$result = $db->sql_query($sql);	
}

I'm only getting the first record imported to the table, and I don't know why.

Here is the structure of my table:

#
# Table structure for table `atlas_tl_session_grade_import`
#

  `ReportNumber` int(3) NOT NULL default '0',
  `StudentID` varchar(9) character set latin1 default '0',
  `StudentName` varchar(50) character set latin1 default '0',
  `Total_RS` tinyint(4) NOT NULL default '0',
  `Total_Percent` tinyint(3) NOT NULL default '0',
  `Percentile` tinyint(3) NOT NULL default '0',
  `1st_Subtest_RS` tinyint(3) NOT NULL default '0',
  `1st_Subtest_Percent` tinyint(3) NOT NULL default '0'

The CHARSET is = utf8

Any help is appreciated.

[NogDog]

Are you sure lines are terminated by '\r\n' and not just '\n'?

[SFDonovan]

That was it.

LINES TERMINATED BY '\r'";