Quote:
|
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.
Okay...truly simple:
Say you have a table named
Questions that has fields such as
questionNumber and
questionText and maybe
points.
SO you simply create another table named
QuestionsHistory with those same fields but ADDING fields
whenChanged and
changedBy and then, before you change any given
Questions records you do:
Code:
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.