PROS! Counting / Numbering results?

[brianb]

Hi,

I'm looking to print a number next to each result generated from a query. For instance, say there were 5 results in my query...how would I make it look like this:

1. This is result 1
2. This is result 2
3. This is result 3
4. This is result 4
5. This is result 5

Any coding examples would be greatly appreciated!

Thanks in advance!

[philipolson]

Here is one way:

$sql = "SELECT fname, lname FROM bar LIMIT 5";
if (!$result = @mysql_query($sql)) {
    print "Unable to run query ($sql) : " . mysql_error();
    exit;
}

$i = 0;
if (mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
        print ++$i . " : " . $row['fname'] . " " .  $row['lname'] . "<br />\n";
    }
}