Updating a checkbox value to database for specific row in table

Rough answer to get you started.

Inside the loop, use the row’s record number (a field called ‘IDnumber’, unique, auto) to help name the of a .

The hidden <input> should have an id of something like

<input hidden name="idnumber" value="<?php echo $row[idnumber];?>">

which will cause the vaue of that input field to be the record number of that record. (The <input> statements should be outside of PHP blocks.)

Use the $_POST values to determine which record to update by using the value of the hidden input item (‘idnumber’) – which will be the record number you want to update with the other values in the form.

The loop should be surrounded by a <form> block (outside the loop).