[SOLVED] Draw empty cells in table?

[Thundarfoot]

I am outputing mysql table into php drawn table.

Problem is any empty cells do not get drawn, causing ugly look.

Here is the code I am using, any help is most appreciated.

 

while($row = mysql_fetch_array( $result )) {

echo "<tr><td>";

echo $row['Name'];

echo "</td><td>";

echo $row['Class'];

echo "</td><td>";

            echo $row['Grade'];

echo "</td><td>";

      echo $row['Comments'];

echo "</td><td>";

      echo $row['Pic'];

echo "</td></tr>";

[awpti]

If a result is empty, echo out  

 

You'll have to do some conditionals

[Thundarfoot]

I guess I should have mentioned I am so noob lol. that was way over my head. but thanks!

[sasa]

try

<?php
while($row = mysql_fetch_array( $result )) {
   echo "<tr><td>";
   echo $row['Name'] ? $row['Name'] : ' ';
   echo "</td><td>";
   echo $row['Class'] ? $row['Class'] : ' ';
   echo "</td><td>";
             echo $row['Grade'] ? $row['Grade'] : ' ';
   echo "</td><td>";
      echo $row['Comments'] ? $row['Comments'] : ' ';
   echo "</td><td>";
      echo $row['Pic'] ? $row['Pic'] : ' ';
   echo "</td></tr>";
}
?>

[Thundarfoot]

Thank you.