How to find Index of an array in php while loop [closed]

Question

I am fetching data from MySQL database... I want to check index of each row... e.g

while($row=mysql_fetch_array($result)
{
i want index of $row in each row... (current Index).
}

Please Help me. Thanks

Answer 1

If you want the index from the database:

<?php
...
$result = mysql_query("SELECT * FROM whatever");

while($row = mysql_fetch_array($result)) {
    echo $row['index']; 
   # Where index is the field name containing the item ID from your database
}
...
?>

Or, if you want to count the number of items based on the output:

<?php
..
$result = mysql_query("SELECT * FROM whatever");
$index = 0;

while($row = mysql_fetch_array($result)) {
    echo $index.' '.$row['whatever'];
    $index++;
}
..
?>

That's what I understood from your question..