พอจะมีวิธีเขียนที่ดีกว่านี้ไหม ทำ list menu โดยดึงมาจาก 2 table แล้วให้แสดงอันที่เลือกไว้

<?php
  if (isset($_POST["submit"])) {
  
    for($i=1;$i<=8;$i++)
{   
    mysql_query("UPDATE rec_product SET product_id = '".$_POST["rec_product$i"]."' WHERE id = '$i' ");
}echo 'Sucessful';
  }
  ?>
<form name="autoSumForm" method="post">
<input type="submit" name="submit" class="btn btn-success" id="submit" value="SAVE"><br /><br />
                <div class="row">
                    <div class="col-lg-4">
                        <div class="panel panel-default">
                        <div class="panel-heading"><strong>RECOMMAND PRODUCT</strong></div>
                        <div class="table-responsive">
<table class="table table-bordered" width="1280" cellspacing="5">
  <?php for($i=1;$i<=8;$i++)
{ ?>
           <tr>
             <td><select name="rec_product<?=$i;?>" id="rec_product<?=$i;?>" class="form-control" width="500" style="width: 500px">
              <?php
                $rec_product = mysql_query("SELECT * FROM rec_product WHERE id = '$i' ");
                $rec_productQuery = mysql_fetch_array($rec_product);

                $productsnowSQL = mysql_query("SELECT * FROM products WHERE id = $rec_productQuery[product_id]");
                $productsnowQuery = mysql_fetch_array($productsnowSQL);

                $productsSQL = mysql_query("SELECT * FROM products");
                  echo '<option value="'.$rec_productQuery['product_id'].'">'.$productsnowQuery['product_name'].'</option>';
                while ($productsQuery = mysql_fetch_array($productsSQL)) {
                  echo '<option value="'.$productsQuery['id'].'">'.$productsQuery['product_name'].'</option>';
                }
              ?>
              </select></td>
			     </tr>
           <?php } ?>
			</table></div>
                        </div>
                    </div>
                </div>
           </form>