Hello,
I am working a project using PHP3/4 and MySQL on a UNIX box.
A table in my database called Checklist holds numbered items for a list ... it has the following fields:
checklist_id - unique identifier
order_id - the item's number in the list
description - item description
When a user chooses to delete an item from the Checklist table, not only do I want to delete the item, but also subtract 1 from each order_id after the item so there is not a break in the item numbers.
How do I do this???
Thanks,
Nick
I am working a project using PHP3/4 and MySQL on a UNIX box.
A table in my database called Checklist holds numbered items for a list ... it has the following fields:
checklist_id - unique identifier
order_id - the item's number in the list
description - item description
When a user chooses to delete an item from the Checklist table, not only do I want to delete the item, but also subtract 1 from each order_id after the item so there is not a break in the item numbers.
How do I do this???
Thanks,
Nick