pass the value between two table

[afi ali]

im develop a transaction function here. as you can see below, there are two tables. which is the first one is for display the item and the second table is for purchasing. what i want to do is, the row for item in first table is clickable. as the row is click, the item that have been choose come out in the second table. and at the second table cell for discount can be editable and the total price is changing by the discount. is anyone can help me how to pass the value between the two table?

<fieldset>
<legend>Item Show</legend>
<table border="1">
<tr>
  <td>Item Name</td>
    <td>Item Code</td>
    <td>Manufacturer</td>
    <td>Price</td>
    <td>Stock</td>
</tr>
<?php
while($row = mysql_fetch_array($result))
  {
?>
<tr>
  <td><?php echo $row['item_name']; ?></td>
    <td><?php echo $row['item_code']; ?></td>
    <td><?php echo $row['item_manufacturer']; ?></td>
    <td><?php echo $row['sell_price']; ?></td>
    <td><?php echo $row['stock']; ?></td>
</tr>
<?php
}
?>
</table>
</fieldset>

<fieldset>
<legend>Item Sale</legend>
<table border="1">
<tr>
  <td>Item name</td>
    <td>Item Code</td>
    <td>Stock</td>
    <td>Price</td>
    <td>Quantity</td>
    <td>Discount</td>
    <td>Total Price</td>
</tr>
</table>
</fieldset>

[Fou-Lu]

By "table" are you referring to a storage level such as mysql, or are you referring to the visually rendered tables within the HTML?
If you mean the dbms, that's a simple matter of issuing an INSERT statement. The purchase would be related to the provided data.
If you mean visually, that's entirely a Javascript functionality.