function delete_main_menu($menu_name)
{
global $db;
$id = find_menu_id($menu_name);
$sql = $db->query(sprintf("DELETE FROM main_menu1 WHERE m_menu_name='%s'", mysql_real_escape_string($menu_name)));
$db->query("DELETE FROM sub_menu WHERE m_menu_id = {$id}");
// Check for errors
if (!$sql) {
echo "Deleting record failed: (" . $dbcon->errno . ") " . $dbcon->error;
}
}
<?php
require 'header.php';
$msg = "";
$old_main_menu = "";
$old_sub_menu = "";
$_id = $_id1 = "";
if (isset($_POST['action'])) {
switch ($_POST['action']) {
case 'edit_main':
$old_main_menu = $_POST['main_menu'];
$_id = find_menu_id($old_main_menu);
break;
case 'edit_sub':
$old_sub_menu = $_POST['sub_menu'];
$_id1 = find_submenu_id($old_sub_menu);
break;
case 'update_main':
$name = $_POST['new_main_name'];
$edit_id = $_POST['edit_id'];
$msg = update_mainmenu($name, $edit_id);
break;
case 'update_sub':
$name = $_POST['new_sub_name'];
$edit_id = $_POST['edit_id'];
$msg = update_submenu($name, $edit_id);
# code...
break;
}
}
?>
