Sum Problem

[rahia307]

hi.
how r u.
i have problem i sum query using php and database is mysql.
structure of my database like this
i have three table.
1. users
this table contain the following fields
id_user, user_name, id_country
2. country
id_country , country_name
3. amount
id_amt, id_user, amount

now i want to get the sum of amount country vise. in amount table one users have multiple entry of amounts.
how i can get the sum of amount.
i want result look like this .

country amount
UK 25000$

any body have idea about it please help me

[shu]

Try something like:

SELECT b.country_name, SUM(b.amount) AS amount 
FROM users a, country b, amount c 
WHERE a.id_country=b.id_country AND a.id_user=c.id_user 
GROUP BY b.country_name

[rahia307]

hi
i remind the database table structure.

country

that table contain only two fields
id_country, country_name

users

that table contain the following fields.
id_user, user_name, id_country

amount

that table contain the following fields.

id_amt, id_user, amount

in table amount
one user have multiple records.
so i want to get the result like this
country name amount