[PHP-DB] EMERGENCY!!

[John Greco]

I am trying to build a web site for our inventory. I have a mysql DB that i
connect to.
The following code is what I use. The array products wont go past

I tried this first:

$sql5 = "select * from product where whseNum = '".$whseNumber."' order by
prodNum";
$result5 = mysql_query($sql5, $conn) or die (mysql_errno() . ": " .
mysql_error(). "\n");
while ($row5 = mysql_fetch_array($result5))
     {
      $products[] = $row5['prodNum'];
     }
   foreach ($products as $prodNum => $value)
   {
    $sql4 = "UPDATE product SET physCount='".$_POST[$value]."' WHERE
prodNum='".$value."' AND whseNum='".$whseNumber."'";
    $result4 = mysql_query($sql4, $conn) or die(mysql_errno() . ": " .
mysql_error(). "\n");
    echo ("In the loop: ".$value);
   }

Then I tried this:
$sql5 = "select * from product where whseNum = '".$whseNumber."' order by
prodNum";
   $result5 = mysql_query($sql5, $conn) or die (mysql_errno() . ": " .
mysql_error(). "\n");
   while ($row5 = mysql_fetch_assoc($result5))
     {
      $products[] = $row5['prodNum'];
    $sql4 = "UPDATE product SET physCount='".$_POST[$value]."' WHERE
prodNum='".$row5['prodNum']."' AND whseNum='".$whseNumber."'";
    $result4 = mysql_query($sql4, $conn) or die(mysql_errno() . ": " .
mysql_error(). "\n");
    echo ("In the loop: ".$row5['prodNum']."<br>");
     }

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php