Need help with sql query...

**killahboo** · 09-19-2008, 03:35 AM

Im trying to put the top x amount of video uploaders on the main page but not sure of the sql query to use to pull the results from the database. Only used to dealing with one table at a time and there is no record of number of videos in the signup table. Anybody know or have any suggestions to try out?

**grynmoors** · 09-22-2008, 04:58 AM

Are you talking about your top 10 users who upload the most? LIke Joe Blow has uploaded 100 videos, Betty Boop has uploaded 90 videos...etc?

If so, my guess would be to look to the code in the submenu that says how many videos a person has (public and/or private). Or the user.tpl page where it says how many videos that person has uploaded

Code:

I have uploaded {$u_info.total_video} videos. {if $pack.video_limit gt "0"} out of {$pack.video_limit} videos{/if}

which gets that info from the "subscriber" section in the sql thingie and then total_video table.

sql thingie...don't you just love it when I speak technical?