Page 1 of 1

Code Theory: [database] List Positioner

Posted: Thu May 01, 2003 10:25 pm
by phice
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).

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'");
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. :)