[RESOLVED] Get Top5 from downloads based on the downloads counter?

[Terminator]

Hi there,

First of all best wishes for 2006!

Second, me doesn't know how to get a Top5 download list from MySQL

I have a table called downloads with the fields

• dl_id
• dl_userid
• dl_name
• dl_genre
• dl_url
• dl_downloads (has the number on how many times the file is downloaded)

Now I want to show the Top5 downloads based on the dl_downloads and that I can show all information (filename, userid etc) in a table.

Anyone has an idea what qeury to use ?

[Terminator]

Solved it : So easy, me so dumb 😃

SELECT * FROM downloads ORDER BY dl_downloads DESC LIMIT 0,5