2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by sellelim05
0

how many textboxes have you got? Show the code you have so far.

$mysql = "SELECT * FROM jjcmlmar_ozekidb.tbl_POtemp, jjcmlmar_jjcmlmarketing.tbl_product WHERE jjcmlmar_ozekidb.tbl_POtemp.product_id = jjcmlmar_jjcmlmarketing.tbl_product.pd_id";
$myresult = mysql_query($mysql) or die (mysql_error());



while ($myrow = mysql_fetch_assoc($myresult))
{

$mytotal = $myrow['qty'] * $myrow['pd_supplier_price'];
$total += $mytotal;
$total1 = number_format($total,2);
echo "<tr>";
echo "<td class='content'>" . $myrow['product_id'] ."</td>";
echo "<td class='content'>" . $myrow['pd_name'] . "</td>";
echo "<td class='content'>" . $myrow['pd_description'] . "</td>";
echo "<td class='content'>" .$myrow['pd_supplier_price'] ."</td>";
echo "<td class='content'><input type='text' name='$txtQty' size='2' value='".$myrow['PO_qty']."'></td>";
	
echo "<td class='content'>" .$mytotal ."</td>";
echo "<td class='content'><a href='index.php?action=remove&vendor=$vendor&id=$pd_id'>Remove</a></td>";
echo "</tr>";



}
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.