$rply = mysql_query("SELECT * FROM radgroupreply group by GroupName");
while ($row1=mysql_fetch_array($rply)) {
$gname = $row1["GroupName"];
echo "<option value=\"$gname\">$gname";
}
**********/
#########
$str1 = mysql_query("SELECT GroupName FROM radgroupcheck group by GroupName");
while ($row1=mysql_fetch_array($str1)) {
$str2 = mysql_query("SELECT GroupName FROM radgroupreply group by GroupName");
while ($row2=mysql_fetch_array($str2)) {
if ($row1["GroupName"] != $row2["GroupName"]) {
$g=1;
}
}
if ($g) {
$gname = $row1["GroupName"];
echo "<option value=\"$gname\">$gname";
}
}
$str3 = mysql_query(" select radgroupreply.GroupName from radgroupreply left join radgroupcheck on radgroupreply.GroupName = radgroupcheck.GroupName where radgroupcheck.GroupName is NULL group by radgroupreply.GroupName");
while ($row3=mysql_fetch_array($str3)) {
$gname = $row3["GroupName"];
echo "<option value=\"$gname\">$gname";
}
#########
echo "</select></td></tr>";
print ("<tr><td align=center><input type=\"submit\" name=\"submit\" value=\"OK\"><td><input type=\"reset\" name=\"reset\" value=\"Reset\"></td></tr></form>");
print ("</table></center>");
}