[Solved] How to get recently updated MySQL field in a row using PHP (NOT ROW)

Question

You will need to log the change in another table. Like changes with the attributes: id, table, attribute, old_value, new_value, datetime. Then, whenever something changes you add e.g.

id, TESTING, last_name, Doe, DoKnow, 2015-03-06 12:34:56

Then you can use this table to show the latest changes. But in the long run and for big databases you end up with a huge changestable. 😉

Accepted Answer

You will need to log the change in another table. Like changes with the attributes: id, table, attribute, old_value, new_value, datetime. Then, whenever something changes you add e.g.

id, TESTING, last_name, Doe, DoKnow, 2015-03-06 12:34:56

Then you can use this table to show the latest changes. But in the long run and for big databases you end up with a huge changestable. 😉