Paste-1188593442:v:use_geshi-1:v:type-php

[Itch]

global $db_prefix, $scripturl;

$articles = db_query("
        SELECT subject, id, views FROM {$db_prefix}tp_articles WHERE 1 ORDER BY views DESC LIMIT 20", __FILE__, __LINE__);

echo '<div class="smalltext">';

if (mysql_fetch_assoc($articles) == 0)
        echo ' No Articles Submitted';
else
{
        while ($row = mysql_fetch_assoc($articles))
                echo '
         Â·
<a href="', $scripturl ,'?page=', $row['id'], '">', $row['subject'], '</a>
(', $row['views'], ' views';


}

echo '

</div>';

mysql_free_result($articles);