All pastes #525906 Raw Edit

Someone

public text v1 · immutable
#525906 ·published 2007-05-31 16:09 UTC
rendered paste body
<?
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("
					<form method=\"post\" action=\"$_SERVER[PHP_SELF]\">
					<select name=\"menu\" size=\"".count($menu_array)."\">
			");
			for ($l = 0; $l < $i; $l++)
			{
				print("
					<option>".$menu_array[$l][2]."</option>"
 					);
			}
			print("
					</select>
					<br /> 
					<p align=\"left\">
						<input value=\"Up\" type=\"submit\">
					</p>
					</form>
			");
		}
	}
?>