CRUD View - Update multiple records using drop down menu and check boxes

[EarthDay]

Hi there,

I was wondering if someone could point me in the right direction please?

I am trying to alter my CRUD view table by adding a check box to the row and using a drop down menu to update a field in the database for multiple records.

Say that a client has a status of referral and I want to change multiple clients to In Progress, I want to be able to select the clients and use the drop down menu to update the status.

Any help would greatly be appreciated.

Thanks, ED. 

[mac_gyver]

you would use an array name for the checkbox field, with the record id used for either the array index or the checkbox value. only checked checkboxes will be set in the submitted form data, so you can detect if any are set (the field name will be set), and get all the checked record ids. you would then use the submitted status value to update the records with those ids. you can use a single FIND_IN_SET() statement in the WHERE clause to do this using one single database query.