Search the Community

I am working on a item helper script. It consists of users selecting from multiple radio buttons for multiple items and updating them all at once. My question is the code below is used for each item the user has (used in "while ($stmt->fetch()){" statement") . With the way I have it set up, how will I make it so it updates the correct item for the right option? Also. how do I grab the bracket variable use_item[$id] ? <tr width=\"100%\"> <td> <p>$name</p> </td> <td> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"keep\"$check_keep></center> </td> <td width=\"50\"> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"stock\"$check_stock></center> </td> <td width=\"50\"> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"discard\"$check_discard></center> </td> <td width=\"50\"> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"donate\"$check_donate></center> </td> <td width=\"50\"> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"gallery\"$check_gallery></center> </td> <td width=\"50\"> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"gallery3\"$check_gallery3></center> </td> <td width=\"50\"> <center><input name=\"use_item[$id]\" type=\"radio\" id=\"use_item[$id]\" value=\"deposit\"$check_deposit></center> </td> </tr> The form takes them to the page that updates using the information they choose from above. A small snippet below. if(isset($_POST['submit'])){ $use = $_POST['use_item']; foreach($use as $use_item){ $item = $_POST['item_id']; /////// UPDATING MYSQLI INSERTED HERE ////////////////// } } Thank you for your time. Hopefully I posted enough information for your help.