Re: [PHP-DB] Drop down box NOT populated

[Ricardo Lopes]

  ----- Original Message ----- 
  From: Larry Sandwick 
  To: [EMAIL PROTECTED] 
  Sent: Thursday, January 22, 2004 3:46 PM
  Subject: [PHP-DB] Drop down box NOT populated


  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";    <<<<---------- WHAT IS THIS DOING HERE !!!!!



  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