select ("SELECT name From businesscat WHERE name='{$category}'") or die('error in selection.');
$count=mysql_num_rows($select_cat);
if($count==0)
{
$id = $db->insert_sql ( "INSERT INTO `businesscat` (`name` ,`parent`) VALUES ('" . $_POST ['name'] . "', '" . $_POST ['parent'] . "')" );
$msg="Category inserted";
}
//$db->print_last_query();
print "";
exit ();
}
}
if (isset ( $_POST ['bt_update'] ))
{
$id = $db->update_sql ( "update `businesscat` set `name`='" . $_POST ['name'] . "' ,`parent`='" . $_POST ['parent'] . "' where catid=" . $_GET ['cat'] );
//$db->print_last_query();
print "";
}
if (isset ( $_GET ['del'] ))
{
$id = $db->delete ( "delete from businesscat where catid=" . $_GET ['del'] );
//$db->print_last_query();
print "";
}
?>