// INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) if ($stage == "new") { for ($i=0; $i<count($values); $i++) { $sql = "INSERT INTO `mpsr` ("; for ($j=0; $j<count($columns); $j++) { $sql .= "'".$columns[$j]."'"; if ($j != count($columns)-1) $sql .= ","; } $sql .= ") VALUES ("; for ($j=0; $j<count($values[$i]); $j++) { $value = preg_replace('/(\d),/','$1',$values[$i][$j]); $sql .= "'".$value."'"; if ($j != count($values[$i])-1) $sql .= ","; } $sql .= ")"; $qry = mysql_query($sql); if (!$qry) die('An error has occurred: '."$sql<br>".mysql_error()); } }An error has occurred: INSERT INTO `mpsr`('date','group', 'mil3','meters3','product3','wasteProd3','wastePer3','eff3', 'mil1','meters1','product1','wasteProd1','wastePer1','eff1', 'mil2','meters2','product2','wasteProd2','wastePer2','eff2', 'line','avgLine','wasteTotal','wasteProd3','wastePercent','avgEff') VALUES ('1194498000','2UP', '6','','MIGG 15','','0.0','', '6','','MIGG 15','','0.0','', '6','','MIGG 15','','0.0','', '0','0','0','0.0','0.00')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 ''date','group','mil3','meters3','product3','wasteProd3','wastePer3','eff3','mil1' at line 1mpsr table structure:Field Type Collation Attributes Null Default Extra id int(11) No auto_increment date int(11) No group varchar(255) latin1_swedish_ci No mil3 int(4) No meters3 int(7) No product3 varchar(7) latin1_swedish_ci No wasteProd3 int(7) No wastePer3 decimal(4,0) No eff3 decimal(4,0) No mil2 int(4) No meters2 int(7) No product2 varchar(7) latin1_swedish_ci No wasteProd2 int(7) No wastePer2 decimal(4,0) No eff2 decimal(4,0) No mil1 int(4) No meters1 int(7) No product1 varchar(7) latin1_swedish_ci No wasteProd1 int(7) No wastePer1 decimal(4,0) No eff1 decimal(4,0) No line int(7) No avgLine int(7) No wasteTotal int(7) No wastePercent decimal(4,0) No avgEff decimal(4,0) No