I am making a forum-database in DBman. I have it all figured out, except for one thing.
When someone start a new topic then a field called 'Reaction' gets value '0'. When answering it gets the value of the topic-ID it is answering to. This way I can filter out the questions (Reaction=0) or A specific question and all of the answers (ID=10 OR Reaction=10).
Now what I need is, for the question that has been answered to move to first place in the question-listing. I intended to do this by creating another field that's used only for the questions (otherwise it's left blank or '0'). Initially it get the ID-number of the question, but when an answer arrives it gets the ID-number of the answer. This way I can sort it on 'new-ness'.
But: how do I get add_record to àlso update the question-record?
Doe this make sense?
Bart
When someone start a new topic then a field called 'Reaction' gets value '0'. When answering it gets the value of the topic-ID it is answering to. This way I can filter out the questions (Reaction=0) or A specific question and all of the answers (ID=10 OR Reaction=10).
Now what I need is, for the question that has been answered to move to first place in the question-listing. I intended to do this by creating another field that's used only for the questions (otherwise it's left blank or '0'). Initially it get the ID-number of the question, but when an answer arrives it gets the ID-number of the answer. This way I can sort it on 'new-ness'.
But: how do I get add_record to àlso update the question-record?
Doe this make sense?
Bart