Hello,
The more I looked at this error and my query the less I see the error. I need some help guys to track down this quote or something.
The error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
The query:
$query = "INSERT INTO gga_raw_data(device_id, gga_date, nmea, gga_time, latitude, north, longitude, east, fixed_quality, no_of_satelites, hdop, altitude, meters, height_of_geoid, metres, check_sum) values";
$gen_query=$query;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
$numlines++;
$myDay=substr($data[1], 0,2);
$myMonth=substr($data[1], 2,2);
$myYear=substr($data[1], 4,2);
$gga_date = convertToNiceDate($myDay, $myMonth, 2000+$myYear);
$longitude = convertToDegrees($data[6]);
$latitude = convertToDegrees($data[4]);
if (!isset($data[15])) {
$data[15] = '';
}
$gen_query .="('$data[0]','$gga_date','$data[2]','$data[3]','$latitude','$data[5]','$longitude','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]', '$data[15]')',";
if ($numlines % 100 == 0) {
mysql_query(substr($gen_query,0,-1));
$gen_query=$query;
}
}
if ($gen_query!=$query) mysql_query(substr($gen_query,0,-1));
echo $gen_query;
mysql_query($query) or die(mysql_error());
Thank you.
