> > I still don't understand do you mean the "actual" row > number or just a > > display number.
> > > There is no relevant data or use to this number. > > > It is the row number of the returned result set, purely > > > for display. That means no field exists or should exist in the database. I only want to generate at query time. I can't use an autoincrement field since that wont work very well with results that are returned out of order and maybe not with all the data. Using variables is the best response to my question. I just dislike using them cause they are ugly to work with because of the session persistance and because I have to issue multiple queries to do the job. I only want to issue one query. Is there a function to give me a number that increments by one for every row returned? If the answer is no, then no need to go any further other than me putting in a request to implement such ( maybe whatever [EMAIL PROTECTED] was talking about with Oracles ROWNUM ) Thanks for your effort guys... --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php