How to subtract value in bd via php?

Question

PHP

1.) There are two different tables in the table for example BD_clon and BD_lolin
Lines in BD_lolin are deleted after the time expires with this code

$db->Query (" DELETE FROM db_sell WHERE date_del >' $da' ");

and I need that when deleting a row in the BD_clon table, the value in the bazaa column is subtracted

Answer 1

Write a post delete trigger, where you can change the value of a field in a different table with a query. Without a table structure, you won't get a more specific answer.