Posted by afrinspray on 02/07/06 22:13

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

[Back to original message]