Code: Select all
number $pos position UP/DOWN
if($move=="up")
$setting = $pos-1;
elseif($move=="down")
$setting = $pos+1;
else /* Error trap */
die("Unable to determine movement.");
if($move=="up" && $setting==0) /* Error trap */
die("Error, cannot move #1 up.");
query("SELECT * FROM `table` WHERE `position` > '$setting'");
foreach($rowї'position'])
if($move=="up")
$setї$i] = $rowї'position']+1;
elseif($move=="down")
$setї$i] = $rowї'position']-1;
foreach($set)
query("UPDATE `table` SET `position` = '$setї$i]'");
query("UPDATE `table` SET `position` = '$setting'");