Code Theory: [database] List Positioner
Posted: Thu May 01, 2003 10:25 pm
This short theory of code will allow the user to move items (with numbers 1-*) to move his/her items up and down the list (within reason).
This isn't actual coding, it's just a way how one would set up such a positioner. Feel free to use however you wish. 
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'");