hmmm, I never thought of that. Thanks for the help. ;-)
Tyler
----- Original Message -----
From: "michael kimsal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Tyler Longren" <[EMAIL PROTECTED]>
Cc: "PHP-General" <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 9:57 PM
Subject: [PHP] Re: Get row number from mysql
> Tyler Longren wrote:
> > Hello,
> >
> > How can I get the number of the current row, something like this:
> >
> > <?
> > $sql = mysql_query("SELECT * FROM table ORDER BY id DESC");
> > while ($row = mysql_fetch_array($sql)) {
> > $id = $row["id"];
> > $name = $row["name"];
> > print "$current_row_number. $name<Br>";
> > }
> > ?>
> > I can't just use the id field, because the ID's might not always be 1,
2, 3,
> > 4, 5, 6, etc...they could go 1, 2, 4, 5, 8.
> >
> > I need it to look like this:
> > 1. first person
> > 2. second person
> > 3. third person
> >
> > and so on and so forth.
> >
> > Can anyone advise me on how I should do this?
> >
> > thanks,
> > Tyler
> >
> >
>
>
>
> Why not just put a counter in there?
>
> while ($row = mysql_fetch_array($sql)) {
> ++$counter;
> $id = $row["id"];
> $name = $row["name"];
> print "$counter. $name<Br>";
> }
>
>
>
> Michael Kimsal
> http://www.phphelpdesk.com
> PHP support when you need it
> 734-480-9961
>
>
> --
> 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
