Re: Simple Question, hopefully simple answer
| From: | DL Neil | Date: | Fri, 08 Feb 2002 11:50:32 +0000 |
| Subject: | Re: Simple Question, hopefully simple answer | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16666@lists.php.net to get a copy of this message | ||
Luke,
> In one of my mySql tables I have a colum that contains many fields of
> numbers.
> for example
>
> ------------------------
> | id | Name | Age | Sex |
> ------------------------
> |1 | Jim | 17 | m |
> |2 | Dave | 31 | f |
> |3 | Fred | 25 | m |
>
> Ok and I want to get the total value of all the ages out of the table. how
> can I get this?
RTFM (MySQL) for COUNT() and SUM() (and many other useful functions).
Regards,
=dn