I have a multiple row html table with text fields populated by a mysql query in which the text field names are all the same for each row and the text field values are different for each row (value=<? echo $field_name; ?>). The form allows you to update the values in these text fields, but when I submit the query (update table set field_name='$field_name' only the last row of the html table is actually updated. I have been able to make the field names different which allows me to update all records; however, this creates a very long update.php with ever increasing queries. How can I write a query that will update all rows of the html table without having to account for every condition?
TIA - Carroll |🙂
