Help!

[GSHelpBoy]

Use this code:

PHP Code:

<?php
$query = $DB_site->query('SELECT `user`, `amount`, SUM(`amount`) AS `total` FROM `donation` ORDER BY `amount` DESC LIMIT 10');

print('<table>');
print('<tr><th>User</th><th>Donation</th></tr>');
while ($row = $DB_site->fetch_array($query)) {
    print('<tr><td>' . $row['user'] . '</td><td>' . $row['amount'] . '</td></tr>');
}
print('<tr><th colspan="2">Total: ' . $row['total'] . '</th></tr>');
print('</table>');
?>

See how that does.

[chad777]

I think that will work great... i haven't tried yet.

Will that order the users from 1-10 by total amount of user then sum the total of all of them at the buttom?


btw thanks for the code

[chad777]

nope didn't work giving this error

Invalid SQL: SELECT `user`, `amount`, SUM(`amount`) AS `total` FROM `donation` ORDER BY `amount` DESC LIMIT 10

mysql error: Table 'forum.donation' doesn't exist

i have the amount in the user table under field amount?

[GSHelpBoy]

I thought you already had the donation table created...

[chad777]

no i just have a field under the table user called amount which is where I put the amount of the donation.
?

[DrkFusion]

Umm the archive hack of which the structure for was taken from my hack. Anyways

[DrkFusion]

Any hoo, though I am 100% sure it was you, you posted this thread to get help, so it doesn't matter anyways.

[chad777]

I never did a file achieve hack...i think you are thinking of someone else ?

[chad777]

but anyways going back to that script..

I made the donations table with fields (user, amount)

it now displays them in a list but it don't sort them or sum the amounts for each user and put them into a top 10.

also the total amount at the buttom don't work.

I have to change ORDER BY to GROUP BY or i got an error

Invalid SQL: SELECT `user`, `amount`, SUM(`amount`) AS `total` FROM `donation` ORDER BY `amount` DESC LIMIT 10 mysql error: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause