Unnamed

<?
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("
		<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'];
			print("
				<option>".$menu_name."</option>
			");
		}
	}
	print("
			</select>
			<br /> 
			<p align=\"left\">
				<input value=\"up\" type=\"submit\" name=\"up\">
			</p>
			</form>
		");
//	}
?>