bulk insert

[simon551]

I have this form that reads some info in a database that is available for inserting into another table. on each row I have a checkbox. I'd like to take the info out where there is a checkbox marked and insert into my table. Make sense? Any idea how to do this.

 

This is my form:

<form id="form1" name="form1" method="post" action="">
<table width="100%" border="0">
  <?php do { ?>
    <tr>
      <td><?php echo $row_rsSowCats['sowcatID']; ?></td>
      <td><?php echo $row_rsSowCats['sowCategory']; ?></td>
      <td>
        <input type="checkbox" name="checkbox" value="checkbox" />      </td>
      <td> </td>
    </tr>
    <?php } while ($row_rsSowCats = mysql_fetch_assoc($rsSowCats)); ?>
</table>
</form>

 

Not sure how to pull out the info that is selected in order to write into my simple query

$array =

$query="INSERT INTO table VALUES $array";

[Dragen]

the checkbox would have to have a name corresponding to whichever row you want it to effect.. such as:

<input type="checkbox" name="checkbox<?php echo $row_rsSowCats['sowcatID']; ?>" value="checkbox" />

 

then on your page for checking it have an isset check.

<?php
if(isset($_POST['checkbox1'])){
    //the checkbox is checked
}else{
   //the checkbox is not checked
}
?>

obviously if you don't want to do this for every checkbox you could use a foreach statement to go thrtough them