Dynamic Arrays?

[duckfeet]

I have a problem and can't sort it out.

I display several records from a dataset onto a php webpage

What I want to be able to do is to display the records, change the order in which they are displayed on the screen and then redisplay them in that order

In effect I do a looping read of the database
echo the records to the web page in ID order (the order in which the data was input) with a <input type=\"text\" name=\"disporder\" value=\"$count\"> to allow the browser to change the order in which the record will appear.

On submit I want to plug the new position order (disp_ord) back into the database

The approach i think i need is to put the id and the new position into an array

then on submit use the id in the array element to re-read the record from the file

replace the disp_ord in the file with the disp_ord element in the array

then re-write the record with the new disp_ord set

The problem is although I have tried to do this it just does not seem to work

Ideas are urgently needed and gratefully accepted

HELP!😕

[swr]

Display the form:

$query_results = mysql_query("select * from your_table order by disp_ord") or die(mysql_error());
foreach ($query_results as $row) {
    echo "<input type='text' name='disporder_{$row->id}' value='{$row->disp_ord}'><br />\n";
}

Apply the changes:

foreach ($_POST as $key => $value) {
    if (preg_match('/^disporder_(\d+)$/', $key, $matches)) {
        $id = $matches[1];
        if (!is_numeric($value)) die("Non-numeric value");
        mysql_query("update your_table set disp_order = $value where id = $id") or die(mysql_error());
    }
}

The above code is totally untested, but the general approach should work.