Re-ordering result (rank)

[eluser]Rick Jolly[/eluser]
This kind of thing is so easy to do with the help of javascript. You could let the user dynamically update the order, and when finished submit the changes to the database.

I've used scriptaculous to update the order of images using drag and drop. When the user submits the changes, scriptaculous posts an array of image ids in the current order. Then all I have to do is loop through the array and update the order:

Code:

// 'pic_ids' holds a string representing an ordered array of image ids like this: pics[]=2&pics;[]=3&pics;[]=1
$pic_ids = $this->input->post('pic_ids');
// parse_str($pic_ids) creates and assigns the pics array from the $pic_ids string.
parse_str($pic_ids);
if ($pics)
{
   $count = count($pics);
   for ($i = 0; $i < $count; $i++)
   {
      $this->db->where('pic_id', $pics[$i]);
      $this->db->update('pictures_table', array('picture_order' => $i));
   }
}

EDIT: Never mind the semicolons in the pics array example above - the forum is adding those.