=2) { $new_pos_selected = $menu_array[$selected_menu][1]-1; $id_previous = $menu_array[$selected_menu-1][2]; $new_pos_previous = $selected_menu; $selected_id = $_POST['menu']; $update_selected = "UPDATE $tablename SET menu_position=$new_pos_selected WHERE menu_name=\"$selected_id\""; $update_previous = "UPDATE $tablename SET menu_position=$new_pos_previous WHERE menu_name=\"$id_previous\""; mysql_query($update_selected); mysql_query($update_previous); } }elseif($_POST['down']) { $get_menu_positions = mysql_query($query); if($get_menu_positions) { while($row = mysql_fetch_assoc($get_menu_positions)) { $menu_id = $row['menu_id']; $menu_position = $row['menu_position']; $menu_name = $row['menu_name']; $menu_array[$i][0] = $menu_id; $menu_array[$i][1] = $menu_position; $menu_array[$i][2] = $menu_name; if($menu_array[$i][2] == $_POST['menu']) { $selected_menu = $i; } $i++; } } $count_menus = mysql_query($count); $count_result = mysql_result($count_menus,0); if($selected_menu<$count_result) { $new_pos_selected = $menu_array[$selected_menu][1]+1; $id_next = $menu_array[$selected_menu+1][2]; $new_pos_next = $selected_menu; $selected_id = $_POST['menu']; $update_selected = "UPDATE $tablename SET menu_position=$new_pos_selected WHERE menu_name=\"$selected_id\""; $update_next = "UPDATE $tablename SET menu_position=$new_pos_next WHERE menu_name=\"$id_next\""; mysql_query($update_selected); mysql_query($update_previous); } } $get_menu_positions = mysql_query($query); if($get_menu_positions) { $count_menus = mysql_query($count); $count_result = mysql_result($count_menus,0); print("

"); while($row = mysql_fetch_assoc($get_menu_positions)) { $menu_position = $row['menu_position']; $menu_name = $row['menu_name']; if($menu_name == $_POST['menu']) { print(" ".$menu_name." "); }else{ print(" ".$menu_name." "); } } } print("

"); ?>