Yes, there is a particular reason. The actual query I do pulls information
from two tables and has both ORDER BY and GROUP BY clauses. The
"auto_increment" column (think of the query results as a table) will give me
the "rank" of the results. I know how to manipulate the data in PHP to
accomplish what I need. I just thought there might be a way in which the
query could do it up front. Sort of like when you want to know how many
times a particular record exists, you can do a COUNT(*). I just want the
results to basically give me a column in the query that lists the results 1,
2, 3, etc. Make sense?
Thanks for your help!
> -----Original Message-----
> From: Jason Wong [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 13, 2002 8:30 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] possible to add a "record number" to a query?
> On Thursday 13 June 2002 20:27, 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!
> Is there any reason why you need/want to do this? Data are stored
> in a db in
> no particular order. If you want a particular order add an ORDER
> BY clause.
> If you want 'row' numbers then just fudge it in php -- assign a
> row number to
> each record you retrieve from the query.
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> There's such a thing as too much point on a pencil.
> -- H. Allen Smith, "Let the Crabgrass Grow"
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php