need help : updating multiple data

[fandhie]

I have the table Product in my database like this :

Id (int)
Serial(varchar)
Name(varchar)

then I call some (10) data like this :

<?php 
$data=mysql_query("SELECT * FROM product WHERE length(Serial) < 10 LIMIT 10");
 if(mysql_num_rows($data) > 0) { 
       $i=1; ?>             

          <form method="post" action="update.php" name="update">
          <table cellpadding="10">    

          while ($r=mysql_fetch_array($data)){  ?>      

          <tr>
          <td>Serial</td>     

          <td> :  <input type="hidden" name="Id[<?php echo $i; ?>]" value="<?php echo "$r[Id]"; ?>">
          <input type="text" name="BarCode[<?php echo $i; ?>]" value="<?php echo "$r[Serial]"; ?>">
          </td>
          </tr>
          <?php $i++; }   ?>
          <tr><td colspan="2">             

          <input type="submit" name="update" value="Submit" /></td></tr>
          </table></form>  

  <?php  } else {echo "";}  ?>    

how to update all data called once....

thanks for help....

[planetsim]

Seems to be some issues around your while, (missing <?php tag).

The name of the field index keys should really be the index e.g.

<input type="hidden" name="BarCode[<?php echo $r["Id"] ?>]" />

This way you do not need the Id field.

You should receive an array of with the indexes the Ids of each BarCode.

foreach ( $_POST["BarCode"] as $id => $value )
    mysql_query( sprintf( "UPDATE product SET Serial = %s WHERE Id = %d", mysql_real_escape_string( $value ), mysql_real_escape_string( $id ) ) );

Ideally of course you should use a prepared statement for this which would make the update much easier, look into [man]PDO[/man]

Hope this helps a bit.