01.<?php
02.$objConnect = mysql_connect("localhost","carcare","carcare") or die("Error Connect to Database");
03.$objDB = mysql_select_db("mydatabase");
04.$strNextSeq = "";
05.$strSQL = "SELECT * FROM prefix WHERE 1 ";
06.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
07.$objResult = mysql_fetch_array($objQuery);
08.if($objResult["val"] == date("Y"))
09.{
10.$Seq = substr("00000".$objResult["seq"],-5,5);
11.$strNextSeq = $objResult["val"]."-".$Seq;
12.$strSQL = "UPDATE prefix SET seq= seq+1 ";
13.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
14.}
15.else
16.{
17.$Seq = substr("000001",-5,5);
18.$strNextSeq = date("Y")."-".$Seq;
19.$strSQL = "UPDATE prefix SET val = '".date("Y")."' , seq = '1' ";
20.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
21.}
22.echo $strNextSeq;
23.mysql_close($objConnect);
24.?>
Load balance : Server 01
