[RESOLVED] Looping through $_POST

[lerro]

I need some help with this.

How can i loop through a $_POST when the form is submitted, where the ID for several records have been checked using a checkbox as shown below

echo '<input type="checkbox" name="item_id" value="'.$row['item_id'].'" />';

and then make changes accordingly in the database

$sql = "UPDATE itemtable SET state='1' WHERE item_id ='$this->item_id'";

I want it so that all checked item's details are updated accordingly

[Undrium]

Quick and dirty, but gives you a hint how it works:

foreach ($_POST['item_id'] as $id) {
   mysql_query("UPDATE itemtable SET state='1' WHERE item_id ='$id'"); 
}

[lerro]

Thanks.