Most viewed photo

[Slack3R]

Hi to all.

Everytime someone views a photo it records it +1 (like a counter) views in mysql db. How can i determine which is most viewed?

thanks!

[nnichols]

SELECT * FROM tbl_name ORDER BY counter_col DESC LIMIT 5

This returns all columns from "tbl_name" sorted by the value of "counter_col", just the five highest values.

Hope this helps 😉

P.S. If you want a more detailed answer please post again including the structure of the relevant table(s)

[statrat]

or
select max(counter_col) from tbl_name