on my get_question.asp, i was able to insert name, questions, date sucessfully. (obvious answers aren't available yet)

i also have another page display all the questions for people to answers. once they submit answer, i want this answer to go into the samet table tbl_QA, verything stays the same except now "answers" now has just been filled.

at first i thought, i should do insert but insert gave me another record with everything blanks except answers field.

then i thought about update the current table, but it won't work due to some reasons. my query:
UPDATE tble_QA
SET answers='::answers::'
WHERE id=::id::

please help
thanks

There are many ways to do this...but the key is matching the field to be updated with data from an existing field in the same record.