' . $OC_sortImg;
$nsort = '' . OCC_WORD_AUTHOR . '';
} else {
$sortby = "`name_last`, `name_first`";
$idsort = 'Submission ID. Title';
$nsort = '' . OCC_WORD_AUTHOR. '
' . $OC_sortImg;
}
printHeader('All ' . OCC_WORD_AUTHOR . 's', 1);
$accOptions = '';
foreach ($OC_acceptanceValuesAR as $idx => $acc) {
$accOptions .= '';
}
print '
';
$q = "SELECT `" . OCC_TABLE_AUTHOR . "`.`name_last`, `" . OCC_TABLE_AUTHOR . "`.`name_first`, `" . OCC_TABLE_AUTHOR . "`.`email`, `" . OCC_TABLE_AUTHOR . "`.`paperid`, `" . OCC_TABLE_PAPER . "`.`title` FROM `" . OCC_TABLE_AUTHOR . "`, `" . OCC_TABLE_PAPER . "` WHERE `" . OCC_TABLE_PAPER . "`.`paperid`=`" . OCC_TABLE_AUTHOR . "`.`paperid` " . $accSQL . " ORDER BY $sortby";
$r = ocsql_query($q) or err("Unable to get " . oc_strtolower(OCC_WORD_AUTHOR) . "s ".ocsql_errno($r));
if (ocsql_num_rows($r) == 0) { print 'No submissions have been made yet.'; }
else {
$currid = null;
$row = 2; // Seed at 2 to handle same IDs
print '
\n";
}
printFooter();
?>