count nos. of results

[Anon]

How to serialize the database results, i.e., I have this query,
<?
$sqlstr="SELECT * from users WHERE country='USA' ORDER BY Sno ASC";
$result=mysql_query($sqlstr);
while($row=mysql_fetch_array($result)){
echo "$row[Name]";
}
?>
What i need is a number that'll say 1. John
2. James 3. Janet 4. Bill.

Please help

[[deleted]]

So you are looking for a way to print a sequence of numbers?
uhm... how about

$t=0;
while (foo=bar)
{
echo $t;
$t++;
}

[Anon]

Thanks Vincent, I know I can always count on you.