PHP - Modify An Automatically Generated Product List Using Php While() Html From Mysql

hi

i have generated a product list from a mysql table called product_list, once i enter a new product in to the table the product will be shown in the generated list and the list will grow and the table grows.  and i want to allow user the edit/delete/save the products from the generated table, i have no idea how to do it and what is the algorithmic idea to do it so. here is the php and the html code.

<!--Body container  for creating a new product in to the list-->
<div class="body_orderviewform">
  <form name="form1" method="post" action="upload_file.php" enctype="multipart/form-data">
    <p>
      <label for="user_id">User ID:</label>
      <input type="text" name="user_id" id="user_id">
      <label for="customer_name">Customer Name:</label>
      <input type="text" name="customer_name" id="customer_name">
      <label for="customer_family">Customer_family</label>
      <input type="text" name="customer_family" id="customer_family">
      <label for="freelancer_name">Purchaser:</label>
      <input name="freelancer_name" type="text" id="freelancer_name">
     
      <? if (isset($_COOKIE['picAdd'])) echo $_COOKIE['picAdd'];?>
     
    </p>
 <!------------------------------------------------------------------------------------------------------- for generating the list -->
   
<div  class="div.neworder_list" >   

   <div  class="div.neworder_listheader" align="center">
   
    <table width="637" border="1" >
      <tr>
        <td width="193"><label for="link">link:</label>
          <label for="link_new"></label>
          <input type="text" name="link_new" id="link_new"></td>
        <td width="202"><label for="unitprice">Unit Price:</label>
          <label for="Unit_price_new"></label>
          <input type="text" name="Unit_price_new" id="Unit_price_new"></td>
        <td width="220"><label for="qty">Quantity:</label>
          <label for="quantity_new"></label>
          <input type="text" name="quantity_new" id="quantity_new"></td>
      </tr>
      <tr>
        <td><label for="express">Express Fee:</label>
          <label for="express_new"></label>
          <input type="text" name="express_new" id="express_new"></td>
        <td><label for="commission_new">Commission:</label>
          <input type="text" name="commission_new" id="commission_new"></td>
        <td><label for="customer_description">Description</label>
          <label for="description_new"></label>
          <textarea name="description_new" id="description_new" cols="45" rows="5"></textarea></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Picture Upload:
              <input type="hidden" name="<?php echo ini_get("session.upload_progress.name");?>" value="123" />
              <input name="file" type="file" autofocus="autofocus"/>
              <br />


      </tr>
      <tr>
        <td colspan="3"><input type="reset" name="reset" id="reset" value="Reset">
        <input type="submit" name="submit" id="submit" value="Submit The Product"></td>
      </tr>
    </table>

 
</form>   
</div>
   
<div class="neworder_listview">
  <p>
  <form action="" method="post" name="list">
    <input type="submit" name="del" id="del" value="Save">
    <input type="submit" name="save" id="save" value="Del">
  </p>
  <table width="1022" border="1" align="center">
    <tr>
      <th width="24" scope="col">&nbsp;</th>
    <th width="24" scope="col">Row#</th>
    <th width="137" scope="col">Manager</th>
    <th width="137" scope="col">Purchaser Desc</th>
    <th width="40" scope="col"><p>Link</p>
      <p>/Ссылки</p></th>
    <th width="53" scope="col">ФОТО</th>
    <th width="50" scope="col">Unit Price/Цена за еденицу товара</th>
    <th width="46" scope="col">Quantity/ Кол-во</th>
    <th width="138" scope="col">Total Unit Price/ Общая цена</th>
    <th width="89" scope="col">Express/Доставка по Китаю</th>
    <th width="119" scope="col">Description/Описание</th>
    <th width="89" scope="col">ADDITIONAL LINKS/ЗAMЕНЫ</th>
    </tr>
   


<?php

   $username = "my username";
   $password = "my pass";
   $database = "userinfo";
   $link = mysql_connect("localhost", "$username", "$password");
   
   if(!$link) {echo("Failed to establish connection to mysql server");
               exit();}

   $status = mysql_select_db($database);
   $query = "SELECT * FROM order_list";
   $result = mysql_query($query);
   $num = mysql_num_rows($result);
   $i=0;
 
 
 
  while ($i < $num) {
   $field1_name=mysql_result($result,$i,"admin_st");
   $field2_name=mysql_result($result,$i,"freelancer_st");
   $field3_name=mysql_result($result,$i,"link");
   $field4_name=mysql_result($result,$i,"picture");
   $field5_name=mysql_result($result,$i,"unitprice");
   $field6_name=mysql_result($result,$i,"qty");
   $field7_name=mysql_result($result,$i,"express");
   $field8_name=mysql_result($result,$i,"customer_st");
   $i++;
    }
 
?>







<?php
$i=0;
$row=1;
while ($i < $num) {

$f1=mysql_result($result,$i,"admin_st");
$f2=mysql_result($result,$i,"freelancer_st");
$f3=mysql_result($result,$i,"link");
$f4=mysql_result($result,$i,"pic_address");
$f5=mysql_result($result,$i,"unitprice");
$f6=mysql_result($result,$i,"qty");
$f7=mysql_result($result,$i,"express");
$f8=mysql_result($result,$i,"customer_st");
$totao_unit_price = $f5*$f6;
?>
  <tr>
    <td><input type="checkbox" name="del_chbox" id="del_chbox">
   <td><p><font face="Arial"><input name="row_txtbox" type="text" id="row_txtbox" size="2" value="<?php echo $row; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="manager_txtbox" cols="10" id="manager_txtbox"><?php echo $f1; ?></textarea></font></td>
   <td><p><font face="Arial">        <textarea name="purchase_txtbox" cols="10" id="purchase_txtbox"><?php echo $f2; ?></textarea>
</font></td>


   <td><font face="Arial"><a href="<?php $f3 ?>" target="_blank"><?php echo $f3; ?></a></font></td>
   <td><font face="Arial"><img src="<?php echo $f4;?>" width="100" align="middle"100></font></td>
   <td><font face="Arial"><input name="unitprice_txtbox" type="text" id="unitprice_txtbox" size="2" value="<?php echo $f5; ?>"></font></td>
   <td><font face="Arial"> <input name="qty_txtbox" type="text" id="qty_txtbox" size="2" value="<?php echo $f6; ?>"></font></td>
   <td><p><font face="Arial"><?php echo $totao_unit_price; ?></font></td>
   <td><p><font face="Arial"><input name="express2" type="text" id="express3" size="2" value="<?php echo $f7; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="custdesc_txtbox" cols="20" id="custdesc_txtbox"><?php echo $f8; ?></textarea></font></td>
    <td><input name="express2" type="text" id="express3" size="2" value="<?php echo "new link" ?>"></td>
   </tr>

  <p>
    <?php
$i++;
$row++;
}
?>
</table>
   
  </p>
  <p>&nbsp;</p>
  </form>