ทำอย่างไรเมื่อเราแบ่งหน้าแล้วทำให้ไอดีของ record เรียงจากมากไปหาน้อย โดยที่ท่าเรากดลบ record ลำดับของrecord จะเรียงใหม่ทันที

while($r=mysql_fetch_array($rs))
					{
						
						if($_GET["r"]=="edit" && $_GET["smid"]==$r["smid"])
						{
					?>
                <form name="f1" id="f2" method="post" action="emp_update.php">
                  <tr>
                    <td width="30" height="30" align="center" bgcolor="#666666"><?=$ix;?>
                    <input name="tsmid" type="hidden" id="tsmid" value="<?=$r["smid"];?>" size="5" /></td>
                    <td width="80" height="30" align="center" bgcolor="#999999"><input name="tnumber" type="text" id="tnumber" value="<?=$r["number"];?>" size="5" />
                    <input name="number11" type="hidden" id="number11" value="<?=$r["number"];?>" size="5" /></td>
                    <td width="80" height="30" align="center" bgcolor="#999999"><input name="tdiscription" type="text" id="tdiscription" value="<?=$r["dct"];?>" size="5" /><input name="dct11" type="hidden" id="dct11" value="<?=$r["dct"];?>" size="5" /></td>
                                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["date"];?></td>
                    <td width="80" height="30" align="center" bgcolor="#999999" class="txl3"><?=$r["depno"];?></td>
                    <td width="80" height="30" align="center" bgcolor="#666666">

                      <p>
                        <input type="submit" value="Update" />
                        <br />
                        <a href="home.php?idno=<?=$r["smid"];?>&start=<?=$start;?>&page=<?=$page;?>">Cancel</a></p></td>
                    <td width="80" height="30" align="center" bgcolor="#666666"><a href="emp_delete.php?idno=<?=$r["smid"];?>">Delete</a></td>                      
                    </tr>
                  
                   <?
						}
						else
						{
					?>	
                <tr>
                  <td width="30" height="30" align="center" bgcolor="#666666"><?=$ix;?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999" name="dddd"><?=$r["number"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["dct"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["monitor"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["harddisk"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["memory"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["drive"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["keyboard"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["mouse"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["cpu"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#666666"><a href="detail.php?idno=<?=$r["smid"];?>">click</a></td>
                  <td width="80" height="30" align="center" bgcolor="#999999"><?=$r["date"];?></td>
                  <td width="80" height="30" align="center" bgcolor="#999999" class="txl3"><?=$r["depno"];?></td>
             <td width="80" height="30" align="center" bgcolor="#666666"><a href="home.php?smid=<?=$r["smid"];?>&r=edit&start=<?=$start;?>&page=<?=$page;?>">Edit</a></td>
                  <td width="80" height="30" align="center" bgcolor="#666666"><a href="emp_delete.php?smid=<?=$r["smid"];?>">Delete</a></td>                      
                  </tr>
                  </form>
                <?	
						}
					$ix++;
                    }
					
					?>
                  </table>
                    <table width="100%">
                    <tr><td>
                    <?
				for($i=1;$i<=$total_page;$i++)
				{
					if($i != $Page)
					{
						echo "<a href='$PHP_SELF?page=$i' class='menufoot'>$i</a> | ";
						
					}
					else 
					{
					echo "<b>$i</b> | ";
					}
					
               	}