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>
");
}
}
?>