Hello, i am trying to get a table from access to MySQL using CSV file.
I am using this code, but id doesnt upload the data.
include "include.php";
$sep=";";
$filename = "CUSTOMERLIST.csv";
$data = file($filename);
$lun=count($data);
for($i=1; $i<($lun+1); $i++)
{
$row=explode($sep,$data[$i]);
// now with SQL:
$Connect = mysql_connect($DBhost, $DBuser, $DBpass);
mysql_select_db("$DBName");
$query = "INSERT INTO table '$row[0]','$row[1]','$row[2]','$row[3]','$row[4]','$row[5]','$row[6]','$row[7]','$row[8]','$row[9]','$row[10]','$row[11]','$row[12]','$row[13]','$row[14]','$row[15]','$row[16]','$row[17]','$row[18]','$row[19]','$row[20]','$row[21]'";
$result = mysql_query($query);
}
WHATS WRONG?!
Thanks
