i need help with the code below.. the code does not get correct qid from table questions.
let say i enter 2 qtitle, and each qtitle has 3 atitle..
but once the data entered in database..
the error is like below:

(qid=1)qtitle1- i get 6 atitle (by right should be 3 atitle)

(qid=2)qtitle2- i get 12 atitle (by right should be 3 atitle)

anyone can help me to solve this problem.. i realy need some help.. the error is on the coding below..

<?php
foreach ($_POST['questions'] as $q) {
        if (trim($q) != '') {
            $qtitles[] = $q;
        }
    }
 
foreach ($qtitles as $qtitle) {
        $query = "INSERT INTO questions (qtitle) VALUES ('$qtitle')";
        $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
    $qid = mysql_insert_id();
    unset($query);
    unset ($result);
 
foreach ($_POST['options'] as $o) {
        if (trim($o) != '') {
            $atitles[] = $o;
        }
    }
    foreach ($atitles as $atitle) {
        $query = "INSERT INTO answers (qid, atitle, acount) VALUES ('$qid', '$atitle', '0')";
        $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
    }
}
?>

Your array $atitles needs to be cleared in each loop, or all awsers will stock up and be added to all questions. Just put a

$atitles = array();

Before this loop

foreach ($_POST['options'] as $o)

I noticed the atitles array is being added on and not reset by redifining as an empty array $atitles = array()

Also, is there anywhere in the form for the options to check which options go to which questions?