Extra cell in table

[vigour]

Dear forum!

Can someone please tell me why I get 1 extra empty cell at the top of this table? If I have 5 records in my database I get 6 cells in this table. 1 empty at the top and 5 with the content of the database.

echo'<table width="200" border="1" align="center">';
do
{
echo'<tr>';
echo'<td><a href="result.php?letter='.$row["name"] .'"target="main">'.$row["name"].'</a></td>';
echo'</tr>';
}
while($row = mysql_fetch_array($result));
echo'</table>';

[onion2k]

Its because you're using a do..while loop. This will fix your problem:

while($row = mysql_fetch_array($result)) {
echo'<tr>';
echo'<td><a href="result.php?letter='.$row["name"] .'"target="main">'.$row["name"].'</a></td>';
echo'</tr>';
}

Read the manual entry for "do-while" (http://uk.php.net/manual/en/control-structures.do.while.php) if you want to find out the specfic reason behind it.

[vigour]

Originally posted by onion2k
Its because you're using a do..while loop. This will fix your problem:

while($row = mysql_fetch_array($result)) {
echo'<tr>';
echo'<td><a href="result.php?letter='.$row["name"] .'"target="main">'.$row["name"].'</a></td>';
echo'</tr>';
}

Read the manual entry for "do-while" (http://uk.php.net/manual/en/control-structures.do.while.php) if you want to find out the specfic reason behind it. [/B]

Thanks a lot for you help