madjack87

Its very random when it does and doesnt work. Even when doing the exact same steps. The array that is being printed is always correct. I see no problem in the SQL queries that are stored in the array. When I tried to add error checking before I received no errors.. What do you mean by I should be using a prepared query?

I am using jquery and ajax to have a drag and drop sortable table. My problem is that it only works about 10 percent of the time. Here is my js code. <script type="text/javascript"> // When the document is ready set up our sortable with it's inherant function(s) $(document).ready(function() { $("#test-list").sortable({ handle : '.handle', update : function () { var order = $('#test-list').sortable('serialize'); $("#info").load("tow_sort2.php?"+order); } }); }); </script> Here is the tow_sort2.php page: <?php include("../_includes/db_connection.php"); /** * This is where you would inject your sql into the database * but we're just going to format it and send it back */ $array =array(); foreach ($_GET['listItem'] as $position => $item) { $sql = "UPDATE tow SET tow_order = '$position' WHERE tow_id = '$item'"; $conn->query($sql); $array[] = $sql; } print_r($array); ?> Here is the array that is being printed: Array ( [0] => UPDATE tow SET tow_order = '0' WHERE tow_id = '5924' [1] => UPDATE tow SET tow_order = '1' WHERE tow_id = '5925' [2] => UPDATE tow SET tow_order = '2' WHERE tow_id = '5922' [3] => UPDATE tow SET tow_order = '3' WHERE tow_id = '5923' )