Page 1 of 1

update before delete

Posted: 2014-10-14 04:51
by 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.

Re: update before delete

Posted: 2014-10-27 20:06
by tuxor
ok, well the only data is the selected id, with that you can create mysql querys to obtain the info that you need.