Drop down box NOT populated

["Larry Sandwick" <lgs@xxxxxxxxxxx>]

Can anyone tell me what I am missing here,

The Select statement does not populate my drop down window?

My drop down box is empty !

 

 

[snip]

 

<?

 

include '../db.php';

 

$how = mysql_query("SELECT count(distinct(account)) from Backlog") or die ("Something bad happened: " . mysql_error());

$how_many = mysql_result($how, 0);

 

echo "<h3>$how_many Accounts to pick from !!!</h3>";

 

$sql = mysql_query("SELECT distinct(Account) FROM Backlog")or die ("Something bad happened here: " . mysql_error()) ;

 

echo "<select name=\"account\">\n";

echo "<option>\n";

 

while ($row = mysql_fetch_array($sql))

  {

      echo ' <option value="'.$row["account"].'">'.$row["account"]."</option>\n";

 

  }

echo "</select>\n";

 

?>

 

[end snip]

 

 

Larry Sandwick

Sarreid, Ltd.

Network/System Administrator

phone: (252) 291-1414 x223

fax      : (252) 237-1592