We are bulding an intranet for our company. Just to do things like log support calls, keep details of customers servers, computers etc.
What i want to do is have a table that will record changes for each page. If we have the servers table, if somebody updates the ipaddress i would like it to log the previous value, the date and time, the user that did it, the new value and what table and field they changed. Is this kind of thing possible? i would imagine i would need some code that would execute on the insert command that would programatically insert the details into the changes table. Any help or pointers would be great.
View Complete Post