Dropdown box

[Lionel]

I am trying to build a dropdown box from mysql values. I basically duplicated some working code. But why would that one telling me

PHP Code:

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /var/www 


PHP Code:

 $getgroup = mysql_query(" 
SELECT DISTINCT group FROM ".$_CONF['tprefix']."teams ORDER BY group
");
$result_getgroup = mysql_query("$getgroup");
$total_groups = mysql_numrows($result_getgroup);
$g=0;
$myselect = "
<select name=\"group\">
";
while($g < $total_groups) {
$myselect .= "
<option value=\"".mysql_result($result_getgroup,$g,"group")."\">"
.mysql_result($result_getgroup,$g,"group").
"</option>
";
                $g++;
}
 
$myselect .= "
</select>
"; 


[soulfly]

type 'mysql_num_rows' instead of 'mysql_numrows' !