// INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) if ($stage == "new") { for ($i=0; $i".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 1 mpsr 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