Does anyone know how calculate the total value of all the results of a selected field.

Hi

Does anyone know how calculate the total value of the results of a
selected field.

moishyyehuda@gmail.com wrote:
> Hi
>
> Does anyone know how calculate the total value of the results of a
> selected field from a mysql database.

moishyyehuda@gmail.com wrote:

> moishyyehuda@gmail.com wrote:
> > Hi
> >
> > Does anyone know how calculate the total value of the results of a
> > selected field from a mysql database.

er... SUM?

strawberry wrote:
> moishyyehuda@gmail.com wrote:
>
> > moishyyehuda@gmail.com wrote:
> > > Hi
> > >
> > > Does anyone know how calculate the total value of the results of a
> > > selected field from a mysql database.
>
> er... SUM?
sum total my mistake as in john made three payments $1.00 $3.00 $ 2.00
sum total is $6.00

moishyyehuda@gmail.com wrote:

> strawberry wrote:
> > moishyyehuda@gmail.com wrote:
> >
> > > moishyyehuda@gmail.com wrote:
> > > > Hi
> > > >
> > > > Does anyone know how calculate the total value of the results of a
> > > > selected field from a mysql database.
> >
> > er... SUM?
> sum total my mistake as in john made three payments $1.00 $3.00 $ 2.00
> sum total is $6.00

SELECT SUM(payments) AS total FROM table WHERE name = 'John';