Save "last update" for a LOT of columns
Posted: Tue Jan 13, 2009 6:07 am
Hi together,
I just got a real problem, but I hope theres an easy way to do this. Currently, I'm developing a community-like website with lots of profile-content (like gender, smoker, city, got childs, ...). My boss want to ask at specific intervals again for already entered data, just for validation and stuff like this.
Because I know I can't explain things good, here some examples:
User selected "I got no childs yet"
User selected "I'm a smoker"
User selected "I like to drive a car"
Now, i.e. after 1 year, I may want to ask the user again if he still got no childs, is still smoking and loves to drive his car. Idea was to create an "last_update" field for every column, but thats simply impossible with 50-100 columns (seperated to 4 or 5 tables like "profile_basics, profile_interessts", ...) - another idea was to create (this was my boss idea, no mine!) a table for every (!) interessent or "checkbox" I want to keep trackin... but this sounds even crazier.
Long story short:
How to get the time of the last update of a field (column)?
So, I really hope you guys can help me with his matter,
Thank you,
stockholm
I just got a real problem, but I hope theres an easy way to do this. Currently, I'm developing a community-like website with lots of profile-content (like gender, smoker, city, got childs, ...). My boss want to ask at specific intervals again for already entered data, just for validation and stuff like this.
Because I know I can't explain things good, here some examples:
User selected "I got no childs yet"
User selected "I'm a smoker"
User selected "I like to drive a car"
Now, i.e. after 1 year, I may want to ask the user again if he still got no childs, is still smoking and loves to drive his car. Idea was to create an "last_update" field for every column, but thats simply impossible with 50-100 columns (seperated to 4 or 5 tables like "profile_basics, profile_interessts", ...) - another idea was to create (this was my boss idea, no mine!) a table for every (!) interessent or "checkbox" I want to keep trackin... but this sounds even crazier.
Long story short:
How to get the time of the last update of a field (column)?
So, I really hope you guys can help me with his matter,
Thank you,
stockholm