[RESOLVED] How to select 1st, 2nd & 3rd page views from a MySQL Result set

[rr1024]

$res = mysql_query("SELECT MAX(viewed) AS m,q FROM sb_stories_qa GROUP BY id ORDER BY m DESC")

$viewed=mysql_fetch_array($res);

As you can see I can choose the Max and Min very easy but what I want is to choose the Max, next lower than max and second lower to max for
the top 3 pages viewed

[dagon]

ORDER BY by viewed, and LIMIT for the number of results you want.

[rr1024]

dagon;10992679 wrote:

ORDER BY by viewed, and LIMIT for the number of results you want.

Well freaking duh, I don't know why I didn't think of that one....geesh

Thanks ;-)