I am trying to insert each answer for each question in the database. Problem is that there is a possibility that a question may have no answers, so I tried the code below but it does not insert a db row if a question has no answer, what I was trying to do is that if no answer then display the string `No Answer` under the `Answer` column for that question:

```
 $answersql = "INSERT INTO Answer (QuestionId, Answer) 
    VALUES (?, ?)";
if (!$insertanswer = $mysqli->prepare($answersql)) {
    // Handle errors with prepare operation here
    echo __LINE__.': '.$mysqli->error;
}

if( $insert && $insertanswer)
{

    $c = count($_POST['numQuestion']);
    $question_ids = array();

    for($i = 0;  $i < $c; $i++ )
    {

... //Question INSERT goes here

        $questionId = $mysqli->insert_id;

            $question_ids[$questionNo] = $questionId;

}

        $results = $_POST['value'];
        foreach($results as $id => $value) 
        {
            $answer = $value;

            $quesid = (int)$question_ids[$id];   

            foreach($value as $answer) 
            {

            if($answer == '' || $answer === null){
                $answer = 'No Answer';
            }

                $insertanswer->bind_param("is", $quesid, $answer);

                $insertanswer->execute();

                if ($insertanswer->errno) {
                    // Handle query error here
                    echo __LINE__.': '.$insertanswer->error;
                    break 7;
                }
            }
        }

    //close your statements at the end

    $insertanswer->close();

}

```

The `['value']` comes from an input:

```
var $newBtn = $(("<input class='answerBtnsRow answers' type='button' style='display:%s;' onclick='btnclick(this, " + gQuestionIndex + ");' />").replace('%s', $this.is(':visible') ? 'inline-block' : 'none')).attr('name', "value[" + gQuestionIndex + "][]").attr('value', $this.val()).attr('class', $this.attr('class')).attr('id', $this.attr('id') + 'Row');

```

Below is the SHOW CREATE TABLE for the `Answer` Table:

```
CREATE TABLE `Answer` (
 `AnswerId` int(10) NOT NULL AUTO_INCREMENT,
 `QuestionId` int(10) NOT NULL,
 `Answer` varchar(10) DEFAULT NULL,
 PRIMARY KEY (`AnswerId`)
) ENGINE=InnoDB AUTO_INCREMENT=280 DEFAULT CHARSET=utf8

```

Below is a var dump where if I set question 1 to have answers `B` and `C`, question 2 to have no answers, question 3 to have answer `B` and question 4 to have no answer, it outputs the following from var dump:

```
var_dump($question_ids);
    var_dump($results);

array(4) { 
[1]=> int(265) 
[2]=> int(266) 
[3]=> int(267) 
[4]=> int(268) 
} 
[1]=> array(2) { 
[0]=> string(1) "B" 
[1]=> string(1) "C" 
} 
[3]=> array(1) { 
[0]=> string(1) "B" 
} 

```

So it outputs those set of answers in questions 1 and 3. But does not post `No Answer` for question 2 and 4.

If all questions had an answer as thisL

```
question 1: B C
question 2: A
question 3: B
question 4: A C

```

Then the var dump displays this in var dump:

```
array(4) { 
[1]=> int(277) 
[2]=> int(278) 
[3]=> int(279) 
[4]=> int(280) 
} 
array(4) { 
[1]=> array(2) { 
[0]=> string(1) "B" 
[1]=> string(1) "C" } 
[2]=> array(1) { 
[0]=> string(1) "A" 
} 
[3]=> array(1) 
{ 
[0]=> string(1) "B" 
} 
[4]=> array(2) 
{ 
[0]=> string(1) "A" 
[1]=> string(1) "C" 
} }} 

```

As you can see for each question is inserts the relevant answers. So the issu is if the question has no answers that it does not insert a db row and state `No Answer`. My question is how to include a `No Answer`for each question in the db that has no answers selected in those questions?