hello
i have a page that has some javascript on it and it allows me to drag and drop the order of items. kind of like the netflix queue. now i am having trouble updating the records in the database to reorder them.
here is the javascript i am using
Code: Select all
<script type=\"text/javascript\" language=\"javascript\">
function updateOrder(){
var ampcharcode= '%26';
var serializeOpts = Sortable.serialize('item_list')+ unescape(ampcharcode)+\"key=item_list\"+unescape(ampcharcode)+\"update=directors\";
var options = {
method : 'post',
parameters : serializeOpts,
};
alert(options.parameters);
new Ajax.Request('reorder.php',options);
}
Sortable.create('item_list',{tag:'tr', ghosting:true,constraint:'vertical', onUpdate : updateOrder,tree:true})
</script>
here is what i am doing to reorder
Code: Select all
if(isset($_POST['update'])){
foreach($_POST['item_list'] as $key => $value){
$displayorder = $_POST['id'];
$qUpdateDirectors = "update board_members set display_order = '$displayorder' where id = '1' order by display_order";
$rUqUpdateDirectors = mysql_query($qUpdateDirectors) or die (mysql_error());
}
}and here is what i think it is posting
Code: Select all
item_list[0][id]=1&item_list[1][id]=6&item_list[2][id]=5&item_list[3][id]=2&item_list[4][id]=4&item_list[5][id]=3&item_list[6][id]=7&item_list[7][id]=8&item_list[8][id]=9&item_list[9][id]=10&item_list[10][id]=11&key=item_list&update=directorsthanks
pickle | Please use [ code=php ], [ code=text ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: