How to keep Track of Updates..!
-
Hi I have developed a site of Sale/Purchase of Vehicles. We put vehicle's information on other site like greatvehicles.com, ebay, vroom.com etc. Now when a user update its Vehicle Information from his account I need to keep track what information he has changed(eg Make, Model, Photos etc). I need to keep last 5 updates made by user. Please suggest me any koool suggestions to handle it. Please let me know if you need further information regarding this. Thanks in advance Lets work it Out.........!
-
Hi I have developed a site of Sale/Purchase of Vehicles. We put vehicle's information on other site like greatvehicles.com, ebay, vroom.com etc. Now when a user update its Vehicle Information from his account I need to keep track what information he has changed(eg Make, Model, Photos etc). I need to keep last 5 updates made by user. Please suggest me any koool suggestions to handle it. Please let me know if you need further information regarding this. Thanks in advance Lets work it Out.........!
create a table on database say vehicle_history (the fields that you need to keep track of and a number showing the history id) create a update trigger on original table and insert (if the number of records for that vehicle is <5, or insert + delete the oldest or the one with smallest history id). Thats it... Hain Kurt
-
create a table on database say vehicle_history (the fields that you need to keep track of and a number showing the history id) create a update trigger on original table and insert (if the number of records for that vehicle is <5, or insert + delete the oldest or the one with smallest history id). Thats it... Hain Kurt