mysterbx Posted June 3, 2008 Share Posted June 3, 2008 hey... can i count all reads from all grouped downloads? example: <?php $result=mysql_query("select title, category, id, image, views, COUNT(title) as count, reads=reads+views from downloads where category='Movie' group by title order by reads desc limit 0,5"); while($r=mysql_fetch_array($result)) { echo $r[reads]."<br>"; } ?> how it should be working: 1) downloads are grouped 2) all theyr "views" collumns are summed (summed for the same title only) 3) the result is made Link to comment https://forums.phpfreaks.com/topic/108516-count-views/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.