|
|
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
Navigation:
[Reply to this message]
|