关于csv文件数据导入数据库窜行的问题

[robinsonduoduo]

这是csv文件的格式
code,ID,first_name,last_name,gender,dept,1st
1,a,jin,tian,1,1,1
2,b,tian,qi,1,1,2
3,c,hao,hao ,1,2,3
4,d,wo,yao,0,3,1
5,e,chi,fan ,0,4,2

以下是导入后的
0,first_name,last_name,gender,0,1,0
0,jin,tian,1,1,2,0
0,tian,qi,1,2,3,0
0,hao,hao,0,3,1,0
....
都串行了
以下是代码
有啥错误吗
谢谢

<?php
error_reporting(0);
$fname = $_FILES['myfile']['name'];
$do = copy($_FILES['myfile']['tmp_name'],$fname);
if ($do){
	echo  nl2br("\n");
	echo  nl2br("\n");
	echo "<h1><b>Successfully imported.</b></h1><br>";
}else{
	echo " \n";
}

error_reporting(0);
$connect=mysql_connect("localhost","moodle1","000000") or die("Could not connect to the database");
mysql_select_db("grouping",$connect) or die (mysql_error());
mysql_query("set names 'utf8'");
$fname = $_FILES['myfile']['name'];
$handle=fopen("$fname","r");
while($data=fgetcsv($handle,1000,",")){
	$q="insert into ccsv(code,ID,first_name,last_name,gender,dept,1st) values ('$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]')";
	mysql_query($q) or die (mysql_error());
}
fclose($handle);
?>