dynamic combo box?

[lukeurtnowski]

I have a dynamically created combo box

<select name="email" size=1 id="email">
<?php
    while($result = mysql_fetch_assoc($query)) { 
    printf('<option value="'.$result['Email'].'">'.$result['Email'] . '</option>');
    print "\n";
    } 
?>
</select>

Trouble is when no email address exists in the record, a blank option exists which maked the copmbo box look wierd, how can I make it so that if no email address is in the email row of my database no option would be made instead of a blank 1?
Thanks

[abb]

you can check (mysql_num_rows($result) < 1) first, if zero no records, print no record message etc, if more than 1, print the combo box!

[Raju Gautam]

Please see this function which populates the combo:

    function PopulateList($table,$valField,$selField,$selId,$param){
        $opt = "";
        $rs = mysql_query("SELECT $valField,$selField FROM $table WHERE 1 $param ORDER BY $selField ASC") or die(mysql_error());
        while($rows = mysql_fetch_array($rs)){
            if($rows[$valField] == $selId)
                $opt .= "<option value=$rows[$valField] selected>$rows[$selField]</option>";
            else
                $opt .= "<option value=$rows[$valField]>$rows[$selField]</option>";
        }
        return $opt;
    } 

And you can use the function like this:

<select name="countries" id="countries">
<option selected="selected" value="000">Select Country</option>
<?php echo PopulateList("tablename","id field of the table","field to display","the selected value","pass any parameter");?>
</select>

This is my own function. You can ask more if you don't understand.

[CreedFeed]

You can just use an if statement to check if it exists, and if it does, print it out:

<select name="email" size=1 id="email">
<?php
    while($result = mysql_fetch_assoc($query)) {
        if ($result['Email'] != '') { 
            printf('<option value="'.$result['Email'].'">'.$result['Email'] . '</option>');
            print "\n";
        }
    } 
?>
</select>