You throw code to the list with no information about what errors or warnings
you got. Why do you say it doesn't work? What happens when you run the
script?
El Mi� 31 Dic 2003 12:46, John Greco escribi�:
> 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
>
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Mart�n Marqu�s | [EMAIL PROTECTED]
Programador, Administrador, DBA | Centro de Telem�tica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
