[SOLVED] No Idea what to do.

[maxudaskin]

Here is what I want to do.

 

I have a database with flight hours that are specifically assigned to a particular user. I wanted to have the hours added together according to the users... so if there were three entries for 0100, such as 3, 1.5, and 7.5, I want to have them added up and then the top ten users with the most hours to be sorted DESC.

 

[revraz]

Sounds like you want to use SUM and GROUP BY, both are DB/MySQL functions.

[The Little Guy]

Maybe something like so:

 

"SELECT SUM(totaltime) as sumValue FROM tableName WHERE pid = 0100 GROUP BY pirepid"

[Barand]

The only 0100 I can see is in the pid column so

 

SELECT pid, SUM(totaltime) as sumValue 
FROM tableName 
GROUP BY pid
ORDER BY sumValue DESC
LIMIT 10