Deleting MySQL Records from within FORMS

[Anon]

Hi,

Rebuilding an admin tool to manage news articles on a site, originally in asp, rebuilding in PHP.

Problem = I have a delete records page, with the news articles appearing in a list so that the user can select which one to delete.

Client wants this built in a form, with a checkbox next to each record. How can I program the form to process the delete.php page according to which checkbox (and user record) is selected?

:-[

[kailien]

1. I would not actually delete the record
2. I would set up an additional field such as "live" with either a 0 or 1; true or false; etc
3. Only show records that are true for live
4. To delete a record or records (update the live field to false), just make the check box values correspond to the article / news item id number (you did set a unique id number for each record right?)

Since you want to be able to delete multiple records from a single form, you will need to collect all id numbers to be delete (item checked)and put them in an array.

Now, do a loop to update all the records in the array based on their id number.