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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
