query($Query); $flag="sucess"; } if ($_REQUEST["form_action"] == "Insert") { $Query_last_invoice = "SELECT name from shop_category where (name='".$category."' ) "; $name_last_invoice=$DB->query($Query_last_invoice); $noo=mysql_num_rows($name_last_invoice); if($noo==0) { $Query = "insert into $tablename values( NULL,'". $category . "','','','','','','','','','','','','','')"; $DB->query($Query); $flag="sucess"; } else { $flag="failure"; } } } date_default_timezone_set("Asia/Kolkata"); $tablename='tbl_job_details'; if ($update_option == 1) { $id=$_REQUEST['id']; $Query_last_data = "SELECT * from shop_category where category_id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $category=$row_12_123['name']; } ?>

Success! Data Added Sucessfully.

Danger! Already Exists.

Add Category