Hi Skyrail and Vincent, thanks for the help so far! Skyrail, I work in the ubiquitous PHP5/MySQL5 environment.
In a blog somewhere I found a post that said proposed a solution in which you first set a variable, and then have that variable auto-increment, like so:
set @cnt := 0;
select @cnt := @cnt + 1 as cnt, myfield from mytable;
Whew, until an hour ago, I did not even know you could set variables in MySQL. In any case I’m trying the solution on my MySQL Query Browser. Doesn’t seem to work… But my friend, on his PC, says it does work. Go figure.
THanks again for the help. The search continues…