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
