Need help with Multi row form

kavionly · #1 (**permalink**) 09-22-09, 05:56 AM

I have a multi row form. When i do the insertion its not inserting the values i choose, instead its adding in different order. Can u pls help me.

Here is my code

PHP Code:


			
<?php 

require_once "config/functions.inc.php";



//



if(isset($_POST['Submit']))

{

  if ($_POST['mobileno'])

    {          

          extract($_POST) ;

  

         $n = count($mobileno);

   

           $i  = 0;



          while ($i < $n)

          {

       if ($mobileno[$i]== ""){

    

        $i++;

      

      }else{

      

      

              $sql = "insert into transactions set 

                                            executive_name='$executive',

                                            mobile_no='$mobileno[$i]',

                                            Check='$check[$i]',

                                            DEP='$deposit[$i]',

                                            PL='$pl[$i]',

                                            NA='$na[$i]',

                                           ";    

                   

            mysql_query($sql) or die(mysql_error());

        

        $i++;



   }  

} 



}

     

}



        

?>

<html>

<head></head>

<body >

<form method="post" action="transactions.php">

  <table border="1">

    <tr >

      <td  width='83%' >Executive Name

        <input type="text"  size="20"  name="executive"   value="" ></td>

    </tr>

  </table>

  <table width="101%" border="1" cellspacing="2" cellpadding="7" align=center  >

    <?php ?>

    <tr >

      <td width="53" height="40" >Sl ID</td>

      <td width="144" >Mobile No</td>

      <td width="64" >check</td>

      <td width="33" >DEP</td>

      <td width="33" >PL</td>

      <td width="33" >NA</td>

    </tr>

    <?php 

    

    $i=0;

    while($i<20)

    {

    

    $i++;

    

    ?>

    <tr >

      <td  ><strong>

        <input type="hidden" name="key[]" value="<?=$i?>">

        <?=$i?>

        </strong></td>

      <td><input type="text"  name="mobileno[]"  >

      <td  ><strong>

        <input type="checkbox"  size="10"  name="check[]"   value="Yes" >

        </strong> </td>

      <td><strong>

        <input type="checkbox"  size="10"  name="deposit[]"   value="Yes" >

        </strong></td>

      <td><strong>

        <input type="checkbox"  size="10"  name="pl[]"   value="Yes" >

        </strong></td>

      <td><strong>

        <input type="checkbox"  size="10"  name="na[]"   value="Yes" >

        </strong></td>

    </tr>

    <?php }?>

  </table>

  <tr>

    <td width="10%"  ></td>

    <td ><input name="Submit" type="submit" class="buttons" value="Submit">

    </td>

  </tr>

</form>

</body>

</html>

wirehopper · #2 (**permalink**) 09-22-09, 07:45 AM

PHP Code:


			
"insert into transactions set  

                                            executive_name='$executive', 

                                            mobile_no='{$mobileno[$i]}', 

                                            Check='{$check[$i]}', 

                                            DEP='{$deposit[$i]}', 

                                            PL='{$pl[$i]}', 

                                            NA='{$na[$i]}', 

                                           ";