what am i doing wrong

[derksj]

this code does not show the first record
whats wrong

$sql = "SELECT * FROM inschrijvingen ";
      $sql .= "ORDER BY Naam, Voorletters";
      $result = mysql_query($sql,$db) or die(mysql_error($db));
      $row = mysql_fetch_array($result);

echo "<div align=center><center>";
  echo "<table border=1 width=100%>\n";
  echo "<tr>\n";
  echo "<td nowrap><p align=center><b>PersNr.</B>\n";
  echo "<td nowrap><p align=center><b>Naam</B>\n";
  echo "<td nowrap><p align=center><b>Voornaam</b>\n";
  echo "<td nowrap><p align=center><b>Voorletters</B>\n";
  echo "<td nowrap><p align=center><b>Aantal kaarten</B>\n";

  echo "</tr>\n";


  while ($myrow = mysql_fetch_array($result))

 {
  echo "<tr>\n";
  echo "<td nowrap>\n";
  echo "<p align=center>";
  echo $myrow ["Pnr"];
  echo "\n";
  echo "<td nowrap>\n";
  echo "<p align=center>";
  echo urldecode($myrow ["Naam"]);
  echo "\n";
  echo "<td nowrap>\n";
  echo "<p align=center>";
  echo $myrow ["Voornaam"];
  echo "\n";
  echo "<td nowrap>\n";
  echo "<p align=center>";
  echo $myrow ["Voorletters"];
  echo "\n";
  echo "<td nowrap>\n";
  echo "<p align=center>";
  echo $myrow ["Aantal"];
  echo "\n";



}
  echo "</table>";

[derksj]

i already figured it out
thanx

[Roger_Ramjet]

You fetch the first row into $row, do nothing with it and then fetch the second and subsequent rows into $myrow with the while. So that is why you are loosing the first record.

Remove this line and it should be fine: $row = mysql_fetch_array($result);