Trouble with a dynamically created drop down menu
The following will make a drop down with each skill it finds in the users table. It will also show the total number in parenthesis. My problem, however, is that the first entry in the drop down menu is (0). All the rest display correctly. What am I missing here?
$findSkills = "select skills, count(*) as total from users where skills != 'None' group by skills order by skills";
$result = mysql_query ($findSkills) OR die(mysql_error());
$skill = $row["skills"];
$total = number_format($row["total"]);
$pageContent .= "<option value='$skill'>$skill ($total)</option>";
} while($row = mysql_fetch_array($result));