ขอความช่วยเหลือจากผู้รู้ด่วนคับ การเขียนโค้ดตัดสต๊อก จนปัญญาจริงๆๆเเล้วคับ ด่วนมากครับ

<div align="center"> 
                                              <table width="99%" border="0" cellspacing="0" cellpadding="0">
                                                <tr class="jobscss"> 
                                                  <td bgcolor="#FFFFFF"> 
                                                    <?
$page = $_GET['page'];

$select_type="select * from products  order by id asc";
$query_select=mysql_query($select_type);
$num_rows=mysql_num_rows($query_select);

if($num_rows<1){
echo "<br><br><center><font color=#666666 face=tahoma size=2><b>ยังไม่มีการเพิ่มข้อมูลครับ</b></font></center>";
}else{
		$select="select * from products  order by id asc";
		$q_ry = mysql_query($select);
	 	$num_rows=mysql_num_rows($q_ry);
  		$pagesize=8;
		$rt=$num_rows%$pagesize;
		if($rt!=0)
			{
				$totalpage=floor($num_rows/$pagesize)+1;
			}
		else
			{
				$totalpage=floor($num_rows/$pagesize);
				$toppic_id=1;
			}
		if(empty($page))
			{
				$page=1;
			}
		mysql_free_result($q_ry);
		$goto=($page-1)*$pagesize;
$sql_select_mem="Select * From products  order by id asc limit $goto,$pagesize";
		$fect=mysql_query($sql_select_mem);
		if(!$fect)
		{
		("ติดต่อฐานข้อมูลไม่ได้".mysql_error());
		exit;
		}

	  $bgcount=0;
	while($rows=mysql_fetch_array($fect))
	{
$idx =$rows['id'];
$productstypecode  =$rows['productstypecode'];
$productscode = $rows['productscode'];
$productsname = $rows['productsname'];
$productsdetail = $rows['productsdetail'];
$productsprice = $rows['productsprice'];
$productsphoto = $rows['productsphoto'];
$products_price = number_format($productsprice,2,'.',',') ;
$amount = $rows['amount'];
$bgcount=$bgcount+1;
$bgmod=$bgcount%2;
if($bgmod==0){
	$bgcolor="#E9E9E8";
}else{
	$bgcolor="#FFFFFF";
}
	?>
                                                    <table width="100%" border="0" cellspacing="1" cellpadding="1">
                                                      <tr> 
                                                        <td width="463"> <div align="left"> 
                                                            <table width="100%" border="0" cellspacing="1" cellpadding="1">
                                                              <tr> 
                                                                <td width="129"><div align="center"><? echo "<a href=ShowProducts.php?PrdID=$idx><img src=IMG/$productsphoto width=100 height=100 border=0></a>"; ?><br>
                                                                    <font size="2"><strong>อะไหล่คงเหลือ</strong> :</font> <font size="2" color="#990000"><? echo "<u><b>$amount</b></u>"; ?> 
                                                                    <br>
                                                                    <? 
												if ($amount <= 3)
												{
												echo "อะไหล่ใกล้หมดสต๊อก";
												}else{
												echo "";
												}
												if ($amount = 0)
												{
												echo "อะไหล่หมดสต๊อก";
												}else{
												echo "";
												}
												?>
                                                        </font> </div></td>
                                  <td width="362"><p><font size="2"><strong>รหัสอะไหล่</strong></font> :  <? echo "$productscode";  ?> </p>                                                                  <? echo "<font size=2><b><u>$productsname</u></b><br><img src=images/48be2683.gif> $productsdetail<br>ราคา : $products_price บาท</font>"; ?></td>
                                                              </tr>
                                                            </table>
                                                          </div></td>
                                                        <td width="95"> <div align="center"> 
                                                            <table width="60" border="0" cellspacing="1" cellpadding="1">
                                                              <tr> 
                                                                <td width="76"><div align="center"><a href="EditProducts.php?PrdID=<? echo "$idx"; ?>"><img src="image/Desktop.png" width="30" height="30" border="0"></a></div></td>
                                                                <td width="78"><div align="center"><a href="DelProducts.php?PrdID=<? echo "$idx"; ?>&PhotoName=<? echo "$productsphoto"; ?>"><img src="image/XP-ICANDY RECYCLE BIN FULL4.png" width="30" height="30" border="0"></a></div></td>
                                                              </tr>
                                                            </table>
                                                          </div></td>
                                                      </tr>
                                                      <tr> 
                                                        <td colspan="2"><img src="images/line.jpg" width="600" height="3"></td>
                                                      </tr>
                                                    </table>
                                                    <?
}
}
?>
                                                  </td>
                                                </tr>
                                                <tr class="jobscss"> 
                                                  <td><strong><span class="maekhawtom"><font color="#990000" size="2"><br>
                                                    หน้าที่ :</font></span></strong> 
                                                    <font color="#999999" size="2"><span class="maekhawtom"> 
                                                    <? 
	for($i=1;$i<$page;$i++)
	{
	echo"[<a href='$PHP_SELF?page=$i'><font size=2 color='#000000'>$i</font></a>]";
	}
	echo"[<font size=2 color=#000000><b><font size=2 color='#FF00000'>$page</font></b></font>]";
	for($i=$page+1;$i<=$totalpage;$i++)
	{
	echo"[<a href='$PHP_SELF?page=$i'><font size=2 color='#000000'>$i</font></a>]";
	}
	?>
                                                    </span></font><font color="#FFFFFF" size="2"><span class="maekhawtom"> 
                                                    </span></font></td>
                                                </tr>
                                                <tr> 
                                                  <td><div align="center"></div></td>
                                                </tr>
                                              </table>
                                            </div>