get query values but do not show them

[monion]

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> &nbsp &nbsp <?php echo $f2;?>&nbsp &nbsp </td>
<td> &nbsp &nbsp <?php echo $f3;?>&nbsp &nbsp </td>
 
 
<td> &nbsp &nbsp <?php echo $f5;?>&nbsp &nbsp </td>
<td align="center"> <input type='text' name="<?php echo $f2?>quantity"
value="" onkeypress="return noenter()">
 
</tr>
<?php
$i++;
}
?>
</table>

[dlite922]

Don't show them? so don't echo them.

If the other database is on the same host, you can even move the values via SQL. Else just while loop them like you have for the display but do an insert.



Dan

[monion]

Maybe I'm missing something. The preceding is part of a form. I want to import some values from 1 database table and pass them to a seperate one. The only way I know is to perform an <input...name=...> How can I also assign a name to a $variable? I'm new with PHP and mysql so please be patient.

Thanks,
MO

[Dormilich]

you don't need a form for that. the job can be done on the server. basicly you do

// not real code
R1 = connect MySQL-1
R2 = connect MySQL-2
R1 : SELECT ... FROM ...
R2 : INSERT INTO ... VALUES R1

case 1: both database tables are on the same host, this can be done using a single SQL querz (as dlite mentioned)
case 2: there is a lot of code out there that can make this very easy to code. but this code is not as easy to understand as the standard PHP MySQL-functions.