' . $OC_sortImg;
$nsort = 'Count';
} else {
$sortby = "num";
$nsort = 'Count
' . $OC_sortImg;
$csort = 'Country';
}
$q = "SELECT country, COUNT(*) AS num FROM " . OCC_TABLE_AUTHOR . ", " . OCC_TABLE_PAPER . " WHERE " . OCC_TABLE_AUTHOR . ".paperid=" . OCC_TABLE_PAPER . ".paperid AND " . OCC_TABLE_AUTHOR . ".position=" . OCC_TABLE_PAPER . ".contactid $accSQL GROUP BY country ORDER BY $sortby";
$r = ocsql_query($q) or err("Unable to get information");
if (mysql_num_rows($r) == 0) {
print 'No papers available';
} else {
print '
Note: Only the country of the contact author is used for reporting
\n";
$row = 1;
while ($l = mysql_fetch_array($r)) {
print '| ' . $l['country'] . ' | ' . $l['num'] . " |
\n";
if ($row==1) { $row=2; } else { $row=1; }
}
print "
";
}
printFooter();
?>