← Back to branch summary

~jisko-dev/jisko/2.0

« back to all changes in this revision

Viewing changes to pages/tag.php

  • Committer: marcos
  • Date: 2010-01-23 23:46:20 UTC
  • Revision ID: svn-v4:58423b2d-8e2c-498e-b154-3d2a6cb1397a:branches/2.0:91
Fixed problem with tags statistics

Show diffs side-by-side

added added

removed removed

Lines of Context:
pages/tag.php
76
76
        
77
77
        echo '<div style="width:250px"><div class="header_title">'.__('Users that created most tags').'</div>';
78
78
        
79
 
        $query = $db->send("SELECT founder, name, COUNT(name) FROM tags_c GROUP BY founder DESC LIMIT 5");
 
79
        $query = $db->send("SELECT founder, name, COUNT(name) FROM tags_c GROUP BY founder ORDER BY COUNT(name) DESC LIMIT 5");
80
80
        
81
81
        echo '<table style="width:250px"><thead><tr style="font-size:13px;font-family:Arial;font-weight:600;color: rgb(74, 101, 107)"><td>'.__('Nickname').'</td><td style="text-align:center;width:60px">'.__('Created tags').'</td></tr></thead>';
82
82
        while ($row = mysql_fetch_row($query)) {