One more question.
How can I get query values assign them to a variable, but not show them?
for example size, $f4 in the following: How can I pass that value $f4 to the form handle page to submit to the database. I can clearly see how to pass $f2 with quantity stuck on the end.
Basically, I need to pass 3 things: 1) item#, 2) item#quantity and 3) size to a new database.
- mysql_select_db("inventory");
-
$query="SELECT * FROM pecialtymaster where Dental='Y'";
-
$result=mysql_query($query);
-
$num=mysql_numrows($result);
-
mysql_close();
-
?>
-
-
<form action="inventorymaster_form.php" method="post"
-
name="inventorymaster_form" align="left" class="style3" bgcolor="#ffffff"
-
onSubmit="return verifyForm(this);">
-
-
<table border="1" class="mainmenu" border="0" cellpadding="0"
-
cellspacing="0">
-
<?php
-
echo "<table border='1'>
-
<tr>
-
<th>Item #</th>
-
<th>Item Description</th>
-
<th>Size</th>
-
<th>Distribution Quantity</th>
-
<th>Current Quantity</th>
-
</tr>";
-
?>
-
<?php
-
$i=0;
-
while ($i<$num) {
-
$f2=mysql_result($result,$i,"item_number");
-
$f3=mysql_result($result,$i,"item");
-
$f4=mysql_result($result,$i,"size");
-
$f5=mysql_result($result,$i,"distquantity");
-
?>
-
-
<tr>
-
<td>     <?php echo $f2;?>    </td>
-
<td>     <?php echo $f3;?>    </td>
-
-
-
<td>     <?php echo $f5;?>    </td>
-
<td align="center"> <input type='text' name="<?php echo $f2?>quantity"
-
value="" onkeypress="return noenter()">
-
-
</tr>
-
<?php
-
$i++;
-
}
-
?>
-
</table>
