[SOLVED] Totals

[uramagget]

I've tried searching through the documentation of MySQL but the right words on how this is done exactly is just is not successful.. Basically here is my schema:

 

 

Table:

sprites

--id

--title

--sheet_file

--game

--console

--amount

--author

 

I want to do two things, though. For one, I want to have a MySQL query count the total amount in the Database. I have tried:

 

SELECT amount FROM `sprites` AS COUNT

 

Although I don't think that it displays the total 'amount' added...

 

 

Next is the table displaying the submitters. I want to be able to display the submitters, though I want it to display the respectful amount of sprites that user has submitted, while ordering by the greatest amount first.

 

Thanking in advance, and sorry if it sounded a bit..odd.

[.josh]

Okay I'm no expert, but if I read that correct:

 

1) SELECT SUM(amount) AS count FROM sprites

2) SELECT author, count(amount) AS count FROM sprites GROUP BY author ORDER BY count DESC

[uramagget]

Thanks very much. I changed the count() to a sum() for the 2nd one and it works splendidly. Again, thanks.