Re: Drop down box NOT populated

From: <Tristan.Pretty@risk.sungard.com> > Jsut a guess... > Your row has a capital 'A' in the SQL statement, and a lower case 'a' in > teh $row[] call.. > > does that matter? Yep, that would matter, but not the exact problem. I don't know if this thread has already been answered or not, so... The real problem is with this: > $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"; because there is no "account" index in $row. You're not selecting "account", you're selecting "distinct(Account)". So, you could do it the hard way and use $row['distinct(Account)'] as your value or change your SQL to: $sql = mysql_query("SELECT distinct(Account) AS acc FROM Backlog")or die and use $row['acc']. This is called making an alias. You alias the distinct(account) column to be called "acc". You can name the alias what ever you want. If you developed with your error_reporting() set to E_ALL, you'd have gotten a notice about "Undefined index 'account' in $row" that may have tipped you off to all of this. Hope this helps. ---John Holmes...