include("www/db_connect.php"); $i = 0; $menu_array = array(array()); mysql_select_db($dbname,$connection); $get_menu_positions = mysql_query($query); $query = "SELECT * FROM $tablename ORDER BY menu_position ASC"; 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']; if($menu_position != 0) { if($menu_array[$i][2] == $_POST['up'] { $selected_menu = $menu_array[$i][1]; } $menu_array[$i][0] = $menu_id; $menu_array[$i][1] = $menu_position; $menu_array[$i][2] = $menu_name; $i++; } } } for ($l = 0; $l < $i; $l++) { if($menu_array[$l][1] >= 2} { if(($menu_array[$l][2] != $_POST['up']) & ($menu_array[$l][1] < $selected_menu)) { $new_position = $menu_array[$l][1]+1; $update = "UPDATE $tablename SET menu_position=\"$new_position\" WHERE menu_name=\"$menu_array[$l][2]\""; mysql_query($update); } else { $new_position = $menu_array[$l][1]-1; $update = "UPDATE $tablename SET menu_position=\"$new_position\" WHERE menu_name=\"$menu_array[$l][2]\""; mysql_query($update); } } } } else { 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']; if($menu_position != 0) { $menu_array[$i][0] = $menu_id; $menu_array[$i][1] = $menu_position; $menu_array[$i][2] = $menu_name; $i++; } } print("
"); } } ?>