Adding numbered rows/serial numbers to database query result set

Question

Hello i'm having problems adding numbered rows/serial numbers to my database query result. I've used $number to collect the actual number of rows. Then another problem i'm trying to avoid is: Numbering of Column Headers.

Thanks for the help.

<?php
$number = mysql_num_rows($query);

for ($serial = 0; $serial < $number; $serial++)
{
    echo "<tr>". $serial ."</tr>";
}

for ($i = 0; $i < $number_cols; $i++)
{  
    echo "<th>" . mysql_field_name($query, $i) . "</th>\n";
}

while ($row = mysql_fetch_row($query))
{    
    echo "<tr align=center>\n";
    for ($i = 0; $i < $number_cols; $i++)
    {   
        echo "<td>";
        if (!isset($row[$i])) 
        {
            echo "NULL";
        }
        else
        {
            echo $row[$i];
        } 
        echo "</td>\n";
    }
    echo "</tr>\n";
}
echo "</table>"; 
echo "</span>";
echo "</div>";
?>

Answer 1

trying my best to get something sane out of your terrific code.

<?php
$serial = 1;
while ($row = mysql_fetch_row($query))
{    
  echo "<tr align=center>\n";
  echo "<td>";
  echo $serial++;
  echo "</td>\n";
  foreach ($row as $value)
  {   
    echo "<td>$value</td>\n";
  }
  echo "</tr>\n";
}