hi
imagine that i have an UPDATE like this :
"UPDATE table SET item_rank='".n."' WHERE cat_id='".$cat_id."'"
that will update all the rank column values to n
is it possible that the value n gets incremented with each row that is affected ?
the reason i'm asking is that at the moment i have do to a select to get a list of the id's of items in that category - then have a loop that updates each item in turn, then increment n and do the next one - this works fine but it's not very elegant
thanks