ID'; $nsort = 'Name
' . $OC_sortImg; } else { $sortby = "`paperid`"; $idsort = 'ID
' . $OC_sortImg; $nsort = 'Name'; } printHeader("Authors of $scope", 1); $q = "SELECT `" . OCC_TABLE_AUTHOR . "`.`name_last`, `" . OCC_TABLE_AUTHOR . "`.`name_first`, `" . OCC_TABLE_AUTHOR . "`.`paperid` 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 authors ".mysql_errno($r)); if (mysql_num_rows($r) == 0) { print 'No submissions have been made yet.

'; } else { print "

Link(s):
: ID – Show submission info

\n"; $row = 1; print '\n"; while ($l = mysql_fetch_array($r)) { print '\n"; $row = $rowAR[$row]; } print "
' . $idsort . ' ' . $nsort . "
'.$l['paperid'].' ' . safeHTMLstr($l['name_first']) . ' ' . safeHTMLstr($l['name_last']) . "

' . $idsort . '	' . $nsort . "
'.$l['paperid'].'	' . safeHTMLstr($l['name_first']) . ' ' . safeHTMLstr($l['name_last']) . "

\n"; } printFooter(); ?>