Dynamic HTML Table from MySql query problem *SOLVED*

[cyprus]

Can someone spot why this is not working properley. Its supposed to dynamically create an HTML table from a database query. But the columns are getting repeated, and the captions are misplaced. Many thanks

[code]<?php
if (($result)||(mysql_errno == 0))
{

echo "<table border='1' bordercolor='#000000' bgcolor='#FFFFCC' width='80%'><tr>";

  if (mysql_num_rows($result)>0)
  {
          //loop thru the field names to print the correct headers
          $i = 0;
          while ($i < mysql_num_fields($result))
          {
      echo "<td align='left'>". mysql_field_name($result, $i) . "</td>";
      //
$i++;
    }
    echo "</tr>";
   
    //display the data
    while ($rows = mysql_fetch_array($result))
    {
      echo "<tr>";
      foreach ($rows as $data)
      {
        echo "<td align='center'>". $data . "</td>";
      }
    }
  }else{
    echo "<tr><td colspan='" . ($i+1) . "'>No Results found!</td></tr>";
  }
  echo "</table>";
}else{
  echo "Error in running query :". mysql_error();
}
?>
[/code]

MOD EDIT code tags added

[Barand]

Use mysql_fetch_assoc() instead of mysql_fetch_array()

By default, fetch array gets the values twice, numeric index and fieldname index

[cyprus]

Many thanks Barand, mysql_fetch_assoc($result) fixed my problem. Best regards