Sum of MYSQL fields

[isurujaya]

Hai Masters,
I have a problem in getting the summation of Mysql database several fields.
It is like this.
My database name -BAR
Table - Pda
There are several fields in the table like A1,A2, A3 ... in a one record.
And data( in int type) has been entered already. Numbers have been entered as data.

I want to display the Sum of A1,A2 and A3.. ( total amount of all fiedls in a one record- displaying by one by one acording to records) when i am recalling the data.
Please send me the PHP coding for it.

Or send me the guidelines to make a another field by including the Summation of other fields in the same record.

Thank you.
IS

[amitpatel66]

Hai Masters,
I have a problem in getting the summation of Mysql database several fields.
It is like this.
My database name -BAR
Table - Pda
There are several fields in the table like A1,A2, A3 ... in a one record.
And data( in int type) has been entered already. Numbers have been entered as data.

I want to display the Sum of A1,A2 and A3.. ( total amount of all fiedls in a one record- displaying by one by one acording to records) when i am recalling the data.
Please send me the PHP coding for it.

Or send me the guidelines to make a another field by including the Summation of other fields in the same record.

Thank you.
IS

Try below query:

SELECT A1 + A2 + A3 FROM bar.pda;
 

In PHP you could try something like shown below:

$query = mysql_query("SELECT A1 + A2 + A3 FROM bar.pda");
 

[pbmods]

Heya, isurujaya. Welcome to TSDN!

MySQL has a SUM() function for exactly that.