include("www/db_connect.php"); $i = 1; $menu_array = array(array()); mysql_select_db($dbname,$connection); $query = "SELECT * FROM $tablename WHERE menu_position !=0 ORDER BY menu_position ASC"; $count = "SELECT count(*) FROM $tablename WHERE menu_position != 0"; $get_menu_positions = mysql_query($query); if($_POST['up']) { 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++; } } if($selected_menu>=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); } if($get_menu_positions) { $count_menus = mysql_query($count); $count_result = mysql_result($count_menus,0); print("
"); // } ?>