how to insert from a single form to two different tables?

i have two tables.
Questions.
Answers.

Questions: Qid, QText, ShowDate
Answers: Aid, AText, Qid, CAns

Each question in ‘Questions table’ has four answers options. those options are stored in ‘Answers table’.

[code]Qid QText ShowDate
200 q1 2013-05-22

Aid AText Qid CAns
200a answer1 200 0
200b answer2 200 1
200c answer3 200 0
200d answer4 200 0
[/code]

how to submit all these details from a single form and insert in to database?

Sponsor our Newsletter | Privacy Policy | Terms of Service