sortable divs jquery and codeigniter

[eluser]xwero[/eluser]
Can't you work with the id of the image? Then you can do

Code:

$this->db->query("UPDATE gallery SET rank='".$newrank."' WHERE id='".$id."' ");

I think the check to see if the list rank is changed should be dropped, if you just update each row the overhead will be more or less the same. You should benchmark it to see the results.