Miscellany

//// this is the out put i get when i load/run the page://INSERT INTO quote_price_details (quote_id, fixture_type, material, material_thickness, pcb_width, pcb_length, apertures, carrier_width, carrier_length, num_quote1, num_quote2, num_quote3, num_quote4, num_quote5, num_waveriders, size_waveriders, num_stiffeners, size_stiffeners, num_titanium_edges, size_titanium_edges, num_clampbars, num_tophats, num_knobbies, num_rcbs, size_rcbs, num_plungers, num_boardclips, num_locationpins, num_holes, num_packing, time_design, time_machining, value_waveriders, value_stiffeners, value_titanium_edges, value_clampbars, value_tophats, value_knobbies, value_rcbs, value_plungers, value_boardclips, value_locationpins, value_packing, value_design, value_machining, value_setup, value_assembly, value_deburring, value_cutting VALUES ('7451', 'sws', 'wavemax', '10mm', '50', '50', '1', '100', '100', '1', '5', '10', '0', '0', '2', '10', '2', '10', '2', '10', '1', '2', '3', '4', '40', '5', '6', '7', '8', '9', '240', '60', '6.12618', '4.1897', '8.85054', '1.94719', '1.21471', '4.5', '6.88', '2.25', '12.18', '1.4', '45', '120', '55', '55', '28.05', '59.583333333333', '9.1666666666667')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 'VALUES ('7451', 'sws', 'wavemax', '10mm', '50', '50', '1', '100', '100', '1', '5' at line 1////this is the code i use to form the query://$query9 = "INSERT INTO quote_price_details (quote_id, fixture_type, material, material_thickness, pcb_width, pcb_length, apertures, carrier_width, carrier_length, num_quote1, num_quote2, num_quote3, num_quote4, num_quote5, num_waveriders, size_waveriders, num_stiffeners, size_stiffeners, num_titanium_edges, size_titanium_edges, num_clampbars, num_tophats, num_knobbies, num_rcbs, size_rcbs, num_plungers, num_boardclips, num_locationpins, num_holes, num_packing, time_design, time_machining, value_waveriders, value_stiffeners, value_titanium_edges, value_clampbars, value_tophats, value_knobbies, value_rcbs, value_plungers, value_boardclips, value_locationpins, value_packing, value_design, value_machining, value_setup, value_assembly, value_deburring, value_cutting VALUES ('$quote_id', '$fixture_type', '$material', '$material_thickness', '$pcb_width', '$pcb_length', '$apertures', '$carrier_width', '$carrier_length', '$num_quote[1]', '$num_quote[2]', '$num_quote[3]', '$num_quote[4]', '$num_quote[5]', '$num_waveriders', '$size_waveriders', '$num_stiffeners', '$size_stiffeners', '$num_titanium_edges', '$size_titanium_edges', '$num_clampbars', '$num_tophats', '$num_knobbies', '$num_rcbs', '$size_rcbs', '$num_plungers', '$num_boardclips', '$num_locationpins', '$num_holes', '$num_packing', '$time_design', '$time_machining', '$value_waveriders', '$value_stiffeners', '$value_titanium_edges', '$value_clampbars', '$value_tophats', '$value_knobbies', '$value_rcbs', '$value_plungers', '$value_boardclips', '$value_locationpins', '$value_packing', '$value_design', '$value_machining', '$value_setup', '$value_assembly', '$value_deburring', '$value_cutting')";		<form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">  <div id="edit_buttons">    <input type="hidden" name="query9" value="<?php echo $query9; ?>">    <input type="submit" name="action" value="Save">  </div></form>//// this is the code used when the form is POST'd//case "Save":  // query is being passed through from POST  $query9 = htmlentities($_POST['query9']);  echo $query9;  include("inc/db_connect.php");  $result=mysql_query($query9) or die(mysql_error());  mysql_close();break;