I need some help with the below code. Lets start with the HTML code first...There is a 2 field input form that pulls numbers from MySQL database which is displayed correctly. I can successfully update the QTY (products quantity) field but i cannot the FLAGGED (products isbn) field. On the php code how can i use both qty and flagged and them update the database? Pleaseeeeeee help meeeee
*/
} else if(isset($_POST['confirmed']) && $_POST['confirmed'] ==1) // show "done" page
{
foreach($_POST['update'] as $pid=>$qty)
{
// get the old quantity for logging purposes
$selectql = $db->Execute("SELECT products_quantity, products_isbn FROM ".DB_PREFIX."products WHERE products_id = " . (int)$pid);
$updateql = $db->Execute("UPDATE ".DB_PREFIX."products SET products_quantity = " . (int)$qty . " WHERE products_id = " . (int)$pid);
<form action="ez_update.php" method="post">
<br /><br /><br />The following stock/inventory will be updated: <br /><br />
<?php
foreach($updated as $pid=>$info){
?>
<input type="hidden" name="update[<?php echo $pid; ?>]" value="<?php echo $info['qty'];?>" />
<input type="hidden" name="update[<?php echo $pid; ?>]" value="<?php echo $info['flagged'];?>" />
</form>
<BR>
<form method="post" action="myfile.php">
<input type="text" name="flagged[<?php echo $pid; ?>]" value="<?php echo $info['products_isbn']; ?>"/> <i style="font-size:11px">(Product Flagged)</i><BR>
<input type="text" name="qty[<?php echo $pid; ?>]" value="<?php echo $info['products_quantity']; ?>" />
<input type="submit" name="update[<?php echo $pid; ?>]" value="Update" />
</form>
