Query("SELECT SUM(opus_hits) AS rank, user_nick, opus_tbl.user_id FROM opus_tbl INNER JOIN user_tbl ON opus_tbl.user_id=user_tbl.user_id GROUP BY user_id ORDER BY rank DESC LIMIT 0,10");
$js = 'document.write(\'
\');'."\n";
while ($rs->MoveNext()) {
$js .= 'document.write(\'\');'."\n";
$js .= 'document.write(\' '.$rs->Fields['user_nick'].' | \');'."\n";
$js .= 'document.write(\'
\');'."\n";
$js .= 'document.write(\' |
\');'."\n";
}
$js .= 'document.write(\'
\');'."\n";
echo $js;
?>