how to echo the current row in mysql WHILE loop

[dsaba]

while($row = mysql_fetch_array($query)) {

//do bunch of stuff

//echo the current row# of the query

}

 

how do I echo the current row # in that while statement?

 

its simple I know but didn't find it after checking my usual help resources

 

-thanks

[shaunrigby]

<?php

echo $row['columnName']'

?>

 

Where columnName is the name of the column you want to print from your DB

[dsaba]

you misunderstand me i meant the current numerical row of the query

 

for example: 0

[dsaba]

$i = 0

while($row = mysql_fetch_array($query)) {

$i++;

//do bunch of stuff

//echo the current row# of the query

}