[ReReReSolved] make query to have a field that shows as rows number.

[asmdev]

hi,
i got a query like this

apple     2.50     3.40
banana    2.40     2.90
papaya    1.40     2.30
mangoes   3.40     4.40

what i hope is, the query would also show the number of the records.
like below

1 apple     2.50     3.40
2 banana    2.40     2.90
3 papaya    1.40     2.30
4 mangoes   3.40     4.40

so, anyone of u have any idea.
thanks in advance