Help with top 10

[ian ditch]

Hi

I,m trying to get a top 10 page working on my site... I have allready done a top posters and a top uploaders section as can be seen here-

http://www.british-babes.co.uk/top10.php (totally safe for work content)

Now what I would link to do is to have the top 10 ablums (most viewed Ablums) in a table above these, but i am unsure how this is done.

The 'top posters/uploaders' is done in anycontent3 and the banner is in anycontent2 .

Any help would be appreciated.

[Stramm]

seems to work you just need to do some table cleanup

[ian ditch]

I'm trying to get the top 10 most viewed albums shown in a seperate table.

Any Ideas on how to do this?

[Stramm]

puuh... I wouldn't recommend it. There's no db entry for views on albums. So you'll take some heat on the server if you've some pics and albums. Either a mysql count on the pictures for each album. Not good for huge albums. Or prefetch the aid from the pictures table and sort/ count the array

[ian ditch]

Thanks for your replys Stramm, your input is appreciated.

Keep up the great work