i have a php page that is opened by a form. when opened it displays 100's of rows of data from a database.
what i need to do is have the user click on some rows, using either a link or a checkbox or something
and then submit to the database that "that row" is now "checked" or "flagged" or something. i added a column to the database "flag" with value 0 or 1.
also it is preferable to remain on same page after the database update.
what would be the best way to do this?
-i have tried putting a checkbox in each row, but then i dont know how to build the query at the end to submit multiple rows (how to access each row's name/value)
-i then considered making each row a form itself...but seems bulky. (as i write this and wait for advice, im going to try this method it actually seems the easiest)
-i considered making each row a link....but then how do i submit a query from a link(using javascript?!)