update before delete

[tuxor]

Hi,

Hi, Did you can update table2 before to delete a record from table1?

For example i have this table1:
id=id of item,
name=name of item,
cant=quantity of items

And the table2:
id=id of totals
id_item=id of item, equals from table1
total=total-cant (from table1)

How did you do that?

thank you.

[tuxor]

ok, well the only data is the selected id, with that you can create mysql querys to obtain the info that you need.