Print the sum of the column values.

Question

The question is - How to display the value of the sample? +)

$summa = mysql_query("SELECT SUM(amusd) FROM tabl WHERE status!=0 AND id=$id")or die(mysql_error());

@RattleSneyk - you had a question about two keys and insertion.
Use the INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1;
[Proof] [1] [1]: dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

Accepted Answer · 2014-07-09T14:54:17

Selection elements may have aliases.

 SELECT SUM(amusd) as sum_amusd FROM tabl WHERE status!=0 AND id=$id

Refer to the sum_amusd column (the alias sum_amusd taken as an example, there can be any string.)

PS: the word as can be omitted.

1 answer 1