[FX.php List] RE: looking for advice...

[John Moed]

Alex,

OK, now I see!

You could create a sortID field in your table that the users can modify.
Maybe use an array to store the data until the user is finished moving
everything around and pushes the "save changes" button, which will update
the sortID for all records displayed. In the Header column, your users could
sort by sortID, recipe name, ingredients, cooking time, whatever. You could
have move up / move down buttons and a move to position button for long
distance moves. 200 records might be a little much to store in an array, but
it could be better than thousands of hits on the database to move a record
up or down 1 position.

Just an idea.

Thanks,
John