Need Help updating Multiple records from one Form using PHP

Hi,

I’m hoping someone can help me with a problem I’m having. I’ve looked at a couple of code examples here but I’m having no luck getting this form to Update.

What I need to do is make a form that shows all the plants in my database and all their prices on one page or in one form, make changes to all the prices and then click update to update all records. I have the items showing but cannot get them to update. Here is my code perhaps some of you wizards out there can see where I’ve screwed up. Thanks a bunch.

PAGE CODE:

[code=php]
<?php require_once(‘../Connections/conn_mill.php’); ?>
<?php
mysql_select_db($database_conn_mill, $conn_mill);
$query_rsHours = “SELECT * FROM hours”;
$rsHours = mysql_query($query_rsHours, $conn_mill) or die(mysql_error());
$row_rsHours = mysql_fetch_assoc($rsHours);
$totalRows_rsHours = mysql_num_rows($rsHours);

mysql_select_db($database_conn_mill, $conn_mill);
$query_rsPot = “SELECT * FROM price”;
$rsPot = mysql_query($query_rsPot, $conn_mill) or die(mysql_error());
$row_rsPot = mysql_fetch_assoc($rsPot);
$totalRows_rsPot = mysql_num_rows($rsPot);
if ((isset($_POST[“Update”])) && ($_POST[“Update”] == “form1”)) {
for ($i = 0; $i < count($_POST[‘hiddenID’]); $i++)
{
$updateSQL = sprintf(“UPDATE price SET Price='”.$_POST[‘Price’].”‘ WHERE HiddenID='”.$_POST[‘ID’].”‘ “);

mysql_select_db($database_conn_mill, $conn_mill);
$Result1 = mysql_query($updateSQL, $conn_mill) or die(mysql_error());
}
}
?>
[/code]

The Form

?>
[/code]

Also in #PHP _↴