01.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
02.$objDB = mysql_select_db("mydatabase");
03.$strSQL = "SELECT * FROM customer WHERE CustomerID = '".$_POST["txtCustomerID"]."' ";
04.$objQuery = mysql_query($strSQL);
05.$objResult = mysql_fetch_array($objQuery);
06.if($objResult)
07.{
08. echo "CustomerID already exist.";
09.}
10.else
11.{
