$category=trim(ucfirst($_POST['cat'])); $parent_cat=$_POST['parent']; if (isset ( $_POST ['cat'] )) { if($category=='') { $err_cat="Required"; } elseif(!preg_match("/^[a-z A-Z]+$/",$category)) { $err_cat="Only alphabits allowed."; } else{ $select_cat = $db->select ("SELECT name From businesscat WHERE name='{$category}'") or die('error in selection.'); $count=mysql_num_rows($select_cat); if($count==0) { $insert_cat = $db->insert_sql ("INSERT INTO businesscat (name) VALUES('{$category}')") or die('error in insertion.'); $msg="Category inserted"; } else { $msg="Category already exists."; } } } ?>
|