RE: [PHP] possible to add a "record number" to a query?

> 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. This is an sql question rather than php. When you get your data include record as one of your select criteria... Eg. Select record, first, last from my_table CYA, Dave -- ---------------------------------------------------------------------- Outback Queensland Internet ************************ Longreach ** New Web Site Online * Queensland ************************ Australia W: www.outbackqld.net.au