php - sql table how to adding array of numbers fetched from sql table -


in sql table how adding array of numbers fetched sql table

table given below

   id         country       person        money     1           uk           john          2010    2           usa          henry         120    3           rus          neko          130    4           ger          suka          110    7           can          beater        1450    8           usa          lusi          2501 

this table how add array money without usa.

i want addition money table without usa

$totalmoney=2010+130+110+1450;

sql coding fetching without usa rows how add money values without usa

select id,country,person,money   customers    country !="usa"; 

select sum(money) customers    country !="usa"; 

Comments