Stuff

<?
include("www/db_connect.php");

	$i = 1;
	$selected_menu = 0;
	$new_pos_selected = 0;
	$id_previous = "";
	$selected_id = "";
	$id_next = 0;
	$new_pos_next = 0;
	$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";
	if($_POST['up'])
	{
	$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++;
			}
		}
	
		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);
		}
	}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("
		<form method=\"post\" action=\"$_SERVER[PHP_SELF]\">
		<select name=\"menu\" size=\"$count_result\">
	");
		while($row = mysql_fetch_assoc($get_menu_positions))
		{
			$menu_position = $row['menu_position'];
			$menu_name = $row['menu_name'];
			if($menu_name == $_POST['menu'])
			{
				print("
					<option selected=\"selected\">".$menu_name."</option>
				");
			}else{
			print("
				<option>".$menu_name."</option>
			");
			}
		}
	}
	print("
			</select>
			<br /> 
			<p align=\"left\">
				<input value=\"up\" type=\"submit\" name=\"up\"><input value=\"down\" type=\"submit\" name=\"down\">
			</p>
			</form>
		");
?>