number my results?

[Fritz]

How do I print the Number when I get results...

select username where state='tx'

I can display

bob
tom
zak

I want to know how to add the number..

1. bob
2. tom
3. zak

Kind of like the <OL> tag does in html.

[LordShryku]

blah blah sql query, blah blah mysql_query

$i = 1;
while($row=mysql_fetch_array($result)) {
   echo $i.". ".$row['fieldname']."<br />";
   $i++;
}

or use your <li> tag and set the <ol> before the loop.

[Fritz]

Originally posted by LordShryku

$i++;

[/B]

Super THAT's the ticket I was looking for ...
thanks so much.