so..I want to update the amount of total sales by a user...

If I want to do it from PHP it will result in too many DB queries, so I was wondering if anyone knows a way to do it by using a TRIGGER that updates an specific field from that specific user on update..

I'm thinking something like

BEFORE UPDATE (or should it be AFTER?)

total_sales = OLD.total_sales + NEW.total_sales

Thank you in advance