hi
i use mysql and php. database structure is like this.
i have three tables
one is users
this table contain the basic information about user and also have the id_country.
second is country
this table contain id_country and country name
the third table is user amount.
this table contain id_amount, id_user and amount
now i want to calculate the total amount country vise
i want result look like this
amount table contain multiple amount of one user
country_name total_ amount
if any one have idea about it please help me
