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 | mmarques@xxxxxxxxxx
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
