can I not display empty fields on my dropdown menu?

[ratso]

Is there any way I can not display empty fields that are in my tables from displaying in my dropdown menus?

Could I get MySQL to do it or is it possible in php?

echo ('<select name="c_council">');
$sql = "SELECT c_council_id, c_council_id FROM dropdowns";
$results = mysql_query($sql);
while ($row=mysql_fetch_array($results,MYSQL_ASSOC))
{
print "<option value=".$row["c_council_id"].">".$row["c_council_id"]."</option>\n";
};
echo ('</select>');

Thanks

[examancer]

this should work:

echo ('<select name="c_council">'); 
$sql = "SELECT c_council_id FROM dropdowns"; 
$results = mysql_query($sql); 
while ($row=mysql_fetch_array($results,MYSQL_ASSOC))  { 
  if (strlen($row['c_council_id']) > 0) {
    echo "<option value=" . $row['c_council_id'] . ">" . $row['c_council_id'] . "</option>\n";
  }
}
echo ('</select>');

why were you selecting the same column twice (c_council_id) from the database table (dropdowns)? well I changed that, and I added an "if" loop that makes sure the row contains a value, and if it doesn't its skiped. Hope this helps. I haven't tested the code, so there could be a syntax problem, but I looked it over pretty good.

[ratso]

Worked a treat, thanks a lot!!

I put c_council_id in twice, due to lack of experience, but now I know better

cheers