Little help

[SamiBH]

Hello

 

I want to make block in my site that shows top 5 Uploaders

 

mysql:

 

Table: files

Field: uploader

***

Table: Uploaders

Field: id

***

 

If anyone can help me I will be Very thankful

 

 

[trq]

Where exactly are you stuck?

[SamiBH]

I don't know how to make it read 2 fields and print top 5

 

 

I did top 5 most reply because there was field in Uploaders with how many reply the user did

mysql:

Table: files

Field: reply

 

but there isn't field "files" with how many the user uploaded  :-\

 

mysql:

Table: files

Field: uploader

***

Table: Uploaders

Field: id

[SamiBH]

Edit*

 

mysql:

 

table files

field uploader (uploader id not username)

 

table users

field id (same "uploader" in files)

field username

[trq]

You need to be more explicit with your explanation I'm afraid.

[SamiBH]

ok sorry

 

I have a site that allow user to upload files

 

when user upload a file

 

the record in mysql is like this

 

lets say the user John Uploaded file named John_file

 

in files Table:

Field filename >>>  Jonh_file

Field uploader >>> 56 (id in numbers)

 

***

 

user name and id is in users Table

Field id >>>56

Field username >>> John

 

***

 

I want a code shows top 5 users sorted by how much files they uploded

like

 

#1  john >> 100 files

#2 sam >> 90 files

#3 ....