[SOLVED] Selecting overall top 5

[uramagget]

I want to make a top 5 for a little mods script I downloaded, but in order to be an overall part of the top 5, a mod has to be high in each:

 

# of Downloadeds

# of Installs Marked

# of Views

# of Comments

 

 

Though the Math and performing the SQL query is just complicated. I do not know if there is further information to provide, but if there is, please tell me.

[Barand]

Add the four together and sort in descending order of the total.

[GingerRobot]

You may also wish to multiply by a weighting factor. For example, you may consider that views are less important than the other factors. The query would be something like:

 

SELECT (downloads+installs+views*0.5+comments) as total FROM table ORDER BY total DESC

[uramagget]

Thank you Gingerbot, though I'd like to know one thing though. Do I replace the total with something? Also, my comments are located in another table, for the sake of organization. How would I add something from another table?

[GingerRobot]

Question 1.) No.

 

Question 2.) You'll need to join the tables. Lets say you have a field called id in both, which the join can be performed on. Lets also say downloads and installs are in table1 and views and comments are in table2:

 

SELECT (table1.downloads+table1.installs+table2.views*0.5+table2.comments) as total, table1.id as id FROM table1,table2 WHERE table1.id=table2.id ORDER BY total DESC

[uramagget]

Ah, I get it. Thank you very much, GingerRobot.