Search the Community
Showing results for tags 'update record'.
Found 1 result
-
I have a 3 part form, the first part is filled out and submitted to MySQL by the dispatcher, the tech then clicks on the update record by id link in the search results form and is taken to the form to update the record. The tech fills out what they need in the form and submit it to update the record by unless they fill out ALL of the form fields they record wont update in MySQL, a syntax error will display. If they fill out ALL of the fields the form will submit and update the record fine, problem is they don't always have to fill out all of the fields on the ticket. So here is my code : <?php // database connection // include 'db_connect.php'; //This gets all the other information from the form // start of form inputs // include 'data/var/variables.php'; //Writes the information to the database mysql_query("UPDATE `tickets` SET `work_performed` = '$work_performed', `item_qty1` = '$item_qty1', `item_qty2` = '$item_qty2', `item_qty3` = '$item_qty3', `item_qty4` = '$item_qty4', `item_qty5` = '$item_qty5', `manuf_1` = '$manuf_1', `manuf_2` = '$manuf_2', `manuf_3` = '$manuf_3', `manuf_4` = '$manuf_4', `manuf_5` = '$manuf_5', `part_number1` = '$part_number1', `part_number2` = '$part_number2', `part_number3` = '$part_number3', `part_number4` = '$part_number4', `part_number5` = '$part_number5', `part_description1` = '$part_description1', `part_description2` = '$part_description2', `part_description3` = '$part_description3', `part_description4` = '$part_description4', `part_description5` = '$part_description5', `part_price1` = '$part_price1', `part_price2` = '$part_price2', `part_price3` = '$part_price3', `part_price4` = '$part_price4', `part_price5` = '$part_price5', `price_extension1` = '$price_extension1', `price_extension2` = '$price_extension2', `price_extension3` = '$price_extension3', `price_extension4` = '$price_extension4', `price_extension5` = '$price_extension5', `material_total` = '$material_total', `sales_tax` = '$sales_tax', `shipping_cost` = '$shipping_cost', `work_date1` = '$work_date1', `work_date2` = '$work_date2', `work_date3` = '$work_date3', `work_date4` = '$work_date4', `work_date5` = '$work_date5', `tech_name1` = '$tech_name1', `tech_name2` = '$tech_name2', `tech_name3` = '$tech_name3', `tech_name4` = '$tech_name4', `tech_name5` = '$tech_name5', `cost_code1` = '$cost_code1', `cost_code2` = '$cost_code2', `cost_code3` = '$cost_code3', `cost_code4` = '$cost_code4', `cost_code5` = '$cost_code5', `pay_rate1` = '$pay_rate1', `pay_rate2` = '$pay_rate2', `pay_rate3` = '$pay_rate3', `pay_rate4` = '$pay_rate4', `pay_rate5` = '$pay_rate5', `total_hours1` = '$total_hours1', `total_hours2` = '$total_hours2', `total_hours3` = '$total_hours3', `total_hours4` = '$total_hours4', `total_hours5` = '$total_hours5', `hours_subtotal1` = '$hours_subtotal1', `hours_subtotal2` = '$hours_subtotal2', `hours_subtotal3` = '$hours_subtotal3', `hours_subtotal4` = '$hours_subtotal4', `hours_subtotal5` = '$hours_subtotal5', `total_hours` = '$total_hours', `material_total` = '$material_total', `labor_cost` = '$labor_cost', `grand_total` = '$grand_total' WHERE `id` = '$id'"); mysql_affected_rows(); echo mysql_error(); ?> <html> <body> <center> <br><br><br> <form name="results" method="post" action="ticket_results.php" enctype="multipart/form-data" id="ticketresult"> <input type="submit" class="submit" id="ticketresult" style="width: 165px" value="Do Something"> </form> </center> </body> </html> Now I've been told previously to do the following, change my variables to this: or this, and neither suggestion works. How can I change my code so the form can be submitted without all the fields being filled out?
