Help!

[chad777]

ok this is want i am trying to do.

I have added an extra field to the user table called amtdonation.

what I want to do is make a page that will display the members with the highest amtdonation

Example:

user 1 has 10.00
user 2 has 20.00
and
user 3 has 5.00

what I want to generate is a page that has

1. user 2 20.00
2. User 1 10.00
3. User 3 5.00

Total amount = 35.00

a top list of donators

it would be display like username in one cell and donation in second field

then the total at the buttom

can anyone make this or tell me where to start by giving me some sample code ?

Thanks

[GSHelpBoy]

PHP Code:

$sql = 'SELECT `user`, `amount`, SUM(`amount`) FROM `donation` ORDER BY `amount`'; 


That would select the user, the amount donated by that user, and the sum of all the donations.

[Erwin]

Hi, GSHelpBoy,

Just a friendly reminder - to download hacks and get support you will need to go to this page and enter your email address, to show you are licensed. (you will need to use your customer number and password to access that page)

Thank you.

[chad777]

maybe I better redo this question.

using vb's global tag at the top
what would I have to do to display like I said before ?

[DrkFusion]

Umm u mean vB's

$DB_site-> ??

[chad777]

No the whole code on what i would need

[DrkFusion]

Umm you mean

[sql]$DB_site->query("'SELECT `user`, `amount`, SUM(`amount`) FROM `donation` ORDER BY `amount`');[/sql]

??? Sorry, but you are not being clearn on what you which to accomplish here.

[chad777]

yeah like that but how would I display the output of it into tables to be like a top 10 list ?

[DrkFusion]

You would loop it...in like for instance using a while(), your file archive hack seems to use it...err well of course it does, because the code is from mine :-p....just check out your err file hack, and you will see how to do it.

[chad777]

my file file archive hack ? I didn't make one ?