Re: possible to add a "record number" to a query?

Jeff, You don't tell us which database. If its Oracle then there is ROWID. Using some sort of record number is good for linking tables as it a primary/foreign key, but otherwise why would you want it? If you do not have such a field as this at present (and want one), you could always add one (ALTER TABLE ADD ColName....). This really is a pure sql question, not relevant to php and this list. HTH Chris Jeff Field wrote:

I would like to have a column returned in a query that tells you which record I'm looking at? Sort of like an auto_increment? IOW, the query results would look like: record first last

 1      john    doe
 2      joe     blow
 3      carol   fisher

The table only has first and last, but I want the results to add something like record to tell me which record it is. Thanks for any help! Jeff