Show Committee Members';
if ($OC_configAR['OC_paperAdvocates']) {
$options = '';
print '
';
}
$q = "SELECT `topicname`, `short`, COUNT(`" . OCC_TABLE_REVIEWERTOPIC . "`.`reviewerid`) AS `num` FROM `" . OCC_TABLE_TOPIC . "`, `" . OCC_TABLE_REVIEWERTOPIC . "`, `" . OCC_TABLE_REVIEWER . "` WHERE `" . OCC_TABLE_TOPIC . "`.`topicid`=`" . OCC_TABLE_REVIEWERTOPIC . "`.`topicid` AND `" . OCC_TABLE_REVIEWERTOPIC . "`.`reviewerid`=`" . OCC_TABLE_REVIEWER . "`.`reviewerid` $cmtAdd GROUP BY `" . OCC_TABLE_TOPIC . "`.`topicid` ORDER BY ";
if (!isset($_REQUEST['s']) || ($_REQUEST['s']=="topic")) {
$q .= "`topicname`";
$tsort = 'Topic
' . $OC_sortImg;
$nsort = 'Count';
} else {
$q .= "`num`";
$nsort = 'Count
' . $OC_sortImg;
$tsort = 'Topic';
}
$r = ocsql_query($q) or err("Unable to get information ".ocsql_errno());
if (ocsql_num_rows($r) == 0) {
print 'No reviewers have signed up yet';
} else {
print '
';
$row = 1;
while ($l = ocsql_fetch_array($r)) {
print '| ' . safeHTMLstr(useTopic($l['short'],$l['topicname'])) . ' | ' . $l['num'] . " |
\n";
if ($row==1) { $row=2; } else { $row=1; }
}
print "
";
}
printFooter();
?>