Update more than 1 table

bakamoo

Hello,
My program needs to have a history of changes which is why i have an audit table. Is it possible for editor to edit 2 tables even though only 1 is changed?

ie. I have a customers table which has 2 columns id(primary key) and name(data)
i also have a table called audits which houses changes from all my database, it contains id(primary key), table of change(customers), column changed (name), from(old value), to(new value), dates and who changed it.

Could anyone give me a link how where the tutorial for this is? Thanks!

tangerine

There's an audit logging example here:
https://editor.datatables.net/manual/php/events#Logging-changes

bakamoo

Thanks