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