I've got a table / form that's being built using php, pulling data out of a mysql database.
what i need it to do is:

column 1, show the item image
column 2, pull the item name from the database
column 3, pull the item cost from the database
column 4, get the quantity from the user
column 5, automatically show a subtotal, cost * quantity

bottom of the table - automatically calculate total

what i've got so far:

PHP Code:
<?php
mysqli_select_db
($wowcalc$database_wowcalc);
$query_getitems "SELECT * FROM items";
$getitems mysqli_query($wowcalc$query_getitems) or die(mysqli_error());
$row_getitems mysqli_fetch_assoc($getitems);
$totalRows_getitems mysqli_num_rows($getitems);
?>
<form name="wowcalc">
<table width="800">
<tr><td>Image</td><td>Item Name</td><td>Item Cost Each</td><td>Quantity</td><td>Subtotal</td></tr>
   <tr><td colspan="5"><hr width="800px" /></td></tr>
    <?php
     
do { 
     
?>

      <tr>
        <td><img src="images/<?php echo $row_getitems['image_name']; ?>"/></td>
        <td><?php echo $row_getitems['item_name']; ?></td>
        <td><?php echo $row_getitems['item_cost']; ?><input type="hidden" value="<?php echo $row_getitems['item_cost']; ?>" name="cost" /></td>
        <td><input type="text" name="quantity" size="10" /></td>
        <td></td>
    </tr>


      <?php } while ($row_getitems mysqli_fetch_assoc($getitems)); ?>
</table>
</form>
unfortunately, I don't know javascript, and I havent had any luck finding anything like what I want to do. any help would be greatly appreciated.

Mike Roberson