问发布和查询mysql数据库

EN

$("#photolist").dragsort({
    dragBetween: true,
    dragEnd: saveOrder,
    placeHolderTemplate: "<li class='placeHolder'><div></div></li>"
});

function saveOrder() {
    var data = $("#photolist li").map(function() {
        return $(this).children().find('img').attr('id');
    }).get();

    $("input[name=SortOrder]").val(data.join("|"));
    var map =  $('input[name=SortOrder]').val();
    $.ajax({
        type: 'POST',
        url: 'updatephotoposition.php',
        data: "map=" + map,
        success: function(){  
            alert("success");
        }
    });
};

<?php
include '../dbconnect.php';
$map = explode('|', $_POST['map']);
foreach ($map as $position => $ID)
{
    $query = "UPDATE Photos SET Position = '$position' WHERE PhotoID = '$ID';";
    $result = mysql_query($query) or die(mysql_error());
}
?>