\n"; } } print ' Committee member(s) have been deleted.
Return to Committee Member Listings
';
printFooter();
exit;
}
if (!isset($_GET['s']) || ($_GET['s'] == "id")) {
$sortby = "reviewerid";
$rsortstr = 'ID
' . $OC_sortImg;
$pcsortstr = 'PC';
$nsortstr = 'Name';
} elseif ($_GET['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(); ?>