เกี่ยวกับ autonumber จะเพิ่มค่าทุกครั้งที่มีการ refesh

<?php
//*** Connect to Database **//
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("db_helpdesk");
 
$strNextSeq = "";
 
//*** Check Year ***//
$strSQL = "SELECT * FROM tb_prefix WHERE 1 ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);

//*** Check val = year,month now ***//
if($objResult["val"] == date("Y").date("m"))
{
   $Seq = substr("00000".$objResult["seq"],-5,5);   //*** Replace Zero Fill ***//
    $strNextSeq = $objResult["val"].$Seq;
 
  //*** Update Next Seq ***//
   $strSQL = "UPDATE tb_prefix SET seq= seq+1 ";
   $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
}
else  //*** Check val != year,month now ***//
{
    $Seq = substr("000001",-5,5);   //*** Replace Zero Fill ***//
   $strNextSeq = date("Y").date("m").$Seq;

  //*** Update New Seq ***//
   $strSQL = "UPDATE tb_prefix SET val = '".date("Y").date("m")."' , seq = '1' ";
   $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
}


echo $strNextSeq; 

?>