PHP/MySQL Insert multiple rows into a table -

im using code:

<?php if(isset($_post["submit"])) {     $num = $_post['number'];     ($i = 0; $i < $num; $i++)     {         if($i==0)         {             echo '0';             $answer1 = $_post["answer1"];             $answer2 = $_post["answer2"];             $answer3 = $_post["answer3"];             $answer4 = $_post["answer4"];             $answer5 = $_post["answer5"];             $answer6 = $_post["answer6"];             $answer7 = $_post["answer7"];             $answer8 = $_post["answer8"];         }         else         {             echo 'no 0';             $answer1 = $_post["answer1$i"];             $answer2 = $_post["answer2$i"];             $answer3 = $_post["answer3$i"];             $answer4 = $_post["answer4$i"];             $answer5 = $_post["answer5$i"];             $answer6 = $_post["answer6$i"];             $answer7 = $_post["answer7$i"];             $answer8 = $_post["answer8$i"];         }         //then insert line items lineitems table bill sequence adhocbills table         $sql="insert surveys_completed (survey_sequence, question_seq, answer1, answer2, answer3, answer4, answer5, answer6, answer7, answer8) values ('".$_post["survey_sequence"]."', '".$_post["question_seq"]."', '".$answer1."', '".$answer2."', '".$answer3."', '".$answer4."', '".$answer5."', '".$answer6."', '".$answer7."', '".$answer8."')";         $rs=mysql_query($sql,$conn) or die(mysql_error());         echo $sql.'<br><br>';     } } ?>  <?php /* if(mysql_real_escape_string($_get["string"]) == '') {     echo 'no survey selected';     exit(); } */ if(mysql_real_escape_string($_get["company"]) != '') {     //sql company     $sql="select * surveys company = '".mysql_real_escape_string($_get["company"])."' , string = '".mysql_real_escape_string($_get["string"])."' "; } elseif(mysql_real_escape_string($_get["string"]) != '') {     //sql string     $sql="select * surveys string = '".mysql_real_escape_string($_get["string"])."' "; } $rs=mysql_query($sql,$conn) or die(mysql_error()); $survey=mysql_fetch_array($rs);  echo '<h3>'.$survey["title"].'</h3>'; ?> <form method="post" action="/home.php?id=surveys/complete_survey"> <table width="600" border="0" cellspacing="5" cellpadding="5"> <?php $sql2="select * surveys_questions survey_seq = '".$survey["sequence"]."' "; $rs2=mysql_query($sql2,$conn) or die(mysql_error()); $counter=0; while($survey_questions=mysql_fetch_array($rs2)) {     $counter++;     ?>       <tr>         <td colspan="2"><strong><?php echo $counter; ?>. <?php echo $survey_questions["question"]; ?></strong>         counter<input type="text" name="number" id="number" value="<?php echo $counter; ?>" />         survey<input type="text" name="survey_sequence" id="survey_sequence" value="<?php echo $survey["sequence"]; ?>" />         question<input type="text" name="question_seq" id="question_seq" value="<?php echo $survey_questions["sequence"]; ?>" /></td>       </tr>       <tr>         <td><?php if($survey_questions["answer1"] != '') { echo '<input type="checkbox" name="answer1'.$counter.'" value="y" /> '.$survey_questions["answer1"]; } ?></td>         <td><?php if($survey_questions["answer2"] != '') { echo '<input type="checkbox" name="answer2'.$counter.'" value="y" /> '.$survey_questions["answer2"]; } ?></td>       </tr>       <tr>         <td><?php if($survey_questions["answer3"] != '') { echo '<input type="checkbox" name="answer3'.$counter.'" value="y" /> '.$survey_questions["answer3"]; } ?></td>         <td><?php if($survey_questions["answer4"] != '') { echo '<input type="checkbox" name="answer4'.$counter.'" value="y" /> '.$survey_questions["answer4"]; } ?></td>       </tr>       <tr>         <td><?php if($survey_questions["answer5"] != '') { echo '<input type="checkbox" name="answer5'.$counter.'" value="y" /> '.$survey_questions["answer5"]; } ?></td>         <td><?php if($survey_questions["answer6"] != '') { echo '<input type="checkbox" name="answer6'.$counter.'" value="y" /> '.$survey_questions["answer6"]; } ?></td>       </tr>       <tr>         <td><?php if($survey_questions["answer7"] != '') { echo '<input type="checkbox" name="answer7'.$counter.'" value="y" /> '.$survey_questions["answer7"]; } ?></td>         <td><?php if($survey_questions["answer8"] != '') { echo '<input type="checkbox" name="answer8'.$counter.'" value="y" /> '.$survey_questions["answer8"]; } ?></td>       </tr>     <?php } ?> <tr>     <td colspan="2"><input type="submit" name="submit" id="submit" value="complete survey" /> </tr> </table> </form> 

so there different amount of questions each time, need way make them insert database (one questions per row)

there 3 tables:

surveys
surveys_questions
surveys_completed

the surveys_completed table users answers put.

any ideas?

place answers in array , explode them in query. column names in query can generated based on amount of number in array.

another point: avoid mysql_*-functions, use mysqli or pdo since mysql deprecated.