[PHP-DB] Code Problem.... 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 the 61st ish product, when there are hundreds for it to
deal with.

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>");
     }

___________________________
John Greco
I.T. Department
RAB Electric Manufacturing, Inc.
Tel: 888 RAB-1000
Fax: 888 RAB-1232
Email: [EMAIL PROTECTED]

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