<?php
function reorder_list($changes, $the_table, $the_column)
{
global $dbconn;
if (isset($working_array)) {
unset($working_array);
}
$new_array = array();
$working_array = $changes;
$tweak_array = new tweak_array;
$working_array = $tweak_array->delete($working_array, 1, 3);
$array_of_keys = array_keys($working_array);
$array_of_values = array_values($working_array);
$size = (count($array_of_keys));
for ($j = 0; $j < $size; $j++) {
$current_keys = explode("_", $array_of_keys[$j]);
$new_array[] = ($current_keys[0]);
if ($current_keys[1] != $array_of_values[$j]) {
$old_position = (($current_keys[1]));
$new_position = ($array_of_values[0]);
}
}
$new_array = $tweak_array->move($new_array, $old_position, $new_position);
while (list($key, $value) = each($new_array)) {
$new_key = ($key + 1);
$query = "UPDATE $the_table SET $the_column = '$new_key' WHERE id = '$value'";
$result = mysql_query($query);
}
}
?>