Tossing out array elements based on key?

Anon

I use mysql_fetch_array and return an array with these keys, eg
name, pageviews

I want to go through the array and toss out elements where pageviews are below an arbitrary number, say 50.

I can't do this in mysql because the statement I use is:

select usertable.name, sum(pages.views) as pageviews from where usertable.name=pages.name group by usertable.name order by usertable.name

This will return a list of names in alphabetical order, but I want to throw away the elements that have less than 50 pageviews. I can't see a way to do it in MySQL, is there a simple way to do it in PHP after I get the array?

majik-sheff

This should work:

select usertable.name, sum(pages.views) as pageviews from where usertable.name=pages.name group by usertable.name having pageviews < 50 order by usertable.name

Anon

Thank you, that was just what I needed! This is OT since it's more mysql than php, but this code example is in the mysql docs

mysql> select student_name, AVG(test_score)
-> from student
-> GROUP BY student_name;

Would it be possible to return an average of the top 10 test_scores instead of an average of all scores?

majik-sheff

select student_name, AVG(test_score) as avg from student GROUP BY student_name ORDER BY avg DESC LIMIT 10;

majik-sheff

Sorry, that won't quite work because I used a keyword as a column name (avg). This should work:

SELECT student_name, AVG(test_score) as avg_test_score from student GROUP BY student_name ORDER BY avg_test_score DESC LIMIT 10;