[SOLVED] "Counting" your search results.

[sh0wtym3]

Hey all,

 

Seemingly simply question, I want to take the results I get from the query below:

 

//Show the database results
$query = "SELECT * FROM mail";
        $result = mysql_query($query);

        	while($row = mysql_fetch_assoc($result))
{
    echo "{$row['fname']} {$row['lname']}<br>" .
	 "<b>{$row['email']}</b><br><br>";
}

 

... and number them. For example:

 

1. fname lname

    email

 

2. fname lname

    email

 

3. fname lname

    email

 

Can somebody please point me in the right direction? Normally I'd google it, but I'm not even sure what this function is called. Thanks in advance.

[Zhadus]

For future reference, it is HTML. Ordered listing.

//Show the database results
echo "<ol>";
$query = "SELECT * FROM mail";
        $result = mysql_query($query);

        	while($row = mysql_fetch_assoc($result))
{
    echo "<li>{$row['fname']} {$row['lname']}<br>" .
	"<b>{$row['email']}</b></li>";
}
echo "</ol>";

[sh0wtym3]

Sweet, it works. Thanks.