[php-list] Query Help !!

[j0hncage]

I'm using the following query to populate a drop down on an input
form.  In the MySQL db table column, there are occasional empty fields
and I can get it to a single empty field on the drop down (using
DISTINCT/ ORDER BY) but would prefer not to have any empty spaces
(white space) on the drop down.  Any ideas?

$query = "SELECT DISTINCT bearing
          FROM $table
          ORDER BY bearing"; 
$result = mysql_query($query);

$number = mysql_numrows($result);

   for ($i=0; $i<$number; $i++) {
   $bearing = mysql_result($result,$i,"bearing");
print "<option value=\"$bearing\">$bearing</option>";

}


thanks for any help, 
John