Code Problem.... EMERGENCY!!
| From: | John Greco | Date: | Wed, 31 Dec 2003 15:54:24 +0000 |
| Subject: | Code Problem.... EMERGENCY!! | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32234@lists.php.net to get a copy of this message | ||
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: john@rabweb.com