Get row number from mysql
| From: | Tyler Longren | Date: | Thu, 14 Mar 2002 03:13:34 +0000 |
| Subject: | Get row number from mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-88418@lists.php.net to get a copy of this message | ||
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