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

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


$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' !