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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.