Posted by ZeldorBlat on 10/06/31 11:39

afrinspray wrote:
> I'm trying to optimize this situation... I have a page that has a bunch
> of categories on it, each with an up and down arrow for re-ordering.
> Each category has a field, intCategoryOrder, which is initially zero
> for every category.
>
> When the user first presses up or down on a category, I want to
> populate the intCategoryOrder field for all categories so the first
> category order is one, the second is two, etc... Is there a way to do
> this in one SQL statement instead of x update statements? I'm using
> MySQL 5.0.x.
>
> Thanks,
> Mike

A solution that didn't involve a bunch of update statements would
require the database to somehow "know" what the order should be (as in
a default). Unless you have some implicit ordering you'd like to start
with (for instance, the category names sorted alphabetically) you'll
need to have a bunch of update statements.

[Back to original message]