Print

[ganeshcp]

I want to sort albums by their popularity but I don't think albums have a hits count. So I thought I can sort them by the no. of pics they contain by using

Code: [Select]

    $sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '.
           'filename, url_prefix, pwidth, pheight '.
           'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '.
           'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '.
           'ON a.thumb=p.pid '.
           'WHERE category='.$cat.$album_filter.
           ' ORDER BY a.pic_count DESC '.
           $limit;
the funny thing is when i brwse my db all the stats for albums are empty!

pic_count,  last_addition all are zeroes...

[Nibbler]

They are not used. If you want to do this then you need to adjust the query to count the actual number of hits or pics.