CodeIgniter Forums
drag and drop and one query - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: drag and drop and one query (/showthread.php?tid=2789)

drag and drop and one query - El Forum - 08-24-2007

[eluser]wojtekk[/eluser]
hi
im using script.aculo.us to sort list with drag and drop
In my controller i got method

Code:
function sort()
{
        $ranking = 1;
        foreach ($_POST['tasks_list'] as $id) {    
        $dane = array('ranking' => $ranking);
        $this->Task->update($id,$dane);
            $ranking++;
        }
}
It works but i dont like it because it make a lot of queres(with 100 items in list - 100 updatesSad )
so i made this to made only one

Code:
function sort()
{
        $ranking = 1;
     $querry='';
        foreach ($_POST['tasks_list'] as $id) {
        $querry.=" UPDATE tasks SET ranking = '".$ranking."' WHERE tasks.id ='".$id."';";
            
            $ranking++;
        }
    $this->Task->updateranking($querry);
}


but its dont work
Any suggesttions?