this have to help you!
<?
mysql_connect("localhost","root") or
die ("Couldn't");
mysql_select_db("guestbook") or
die ("Couldn't");
$vars =array("name","location","email");
$fp = fopen ("first.csv","r");
while (!feof($fp))
{
$data = fgetcsv ($fp, 1000, ";");
for ( $i=0; $i < count($data); $i++)
{
$data[$i];
}
$query = "insert into guestbook
(name,location,email)
values ('$vars[0]','$vars[1]','$vars[2]')";
mysql_query($query) or die (mysql_error());
}
fclose ($fp);
?>