' . $OC_sortImg;
$pcsortstr = 'PC';
$nsortstr = 'Name';
} elseif ($_REQUEST['s'] == "pc") {
$sortby = "onprogramcommittee, name_last, name_first";
$pcsortstr = 'PC
' . $OC_sortImg;
$rsortstr = 'ID';
$nsortstr = 'Name';
} else { // name sort
$sortby = "name_last, name_first";
$nsortstr = 'Name
' . $OC_sortImg;
$rsortstr = 'ID';
$pcsortstr = 'PC';
}
$q = "SELECT `reviewerid`, CONCAT_WS(' ',`name_first`,`name_last`) AS `name`, `username`, `email`, `onprogramcommittee`, `comments` FROM `" . OCC_TABLE_REVIEWER . "` $cmtAdd ORDER BY $sortby";
$r = ocsql_query($q) or err("Unable to get information");
if (mysql_num_rows($r) == 0) {
print 'No committee members have signed up yet';
} else {
print "Count: ".mysql_num_rows($r)."
\n";
print '
Note: If you choose to delete committee member(s), any records of papers assigned to them for review or advocacy will also be deleted.
';
}
printFooter();
?>