Yes, i have to keep a history of all changes made in the dB
Finally! That is what I have been asking you since my first post.
Say you have a table named Questions
that has fields such as questionNumber
and maybe points
SO you simply create another table named QuestionsHistory
with those same fields but ADDING fields whenChanged
and then, before you change any given Questions
records you do:
INSERT INTO QuestionsHistory
SELECT NOW(), $idOrNameOfPersonMakingChange, *
FROM Questions WHERE questionNumber = $numberOfQuestionBeingChanged
NOTE: Because of the peculiarities of MySQL, you should put the *ADDED* fields *FIRST* in the QuestionsHistory table. It makes the above query easier to write.