Re: Simple Question, hopefully simple answer
| From: | Jeroen Timmers | Date: | Fri, 08 Feb 2002 11:36:14 +0000 |
| Subject: | Re: Simple Question, hopefully simple answer | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16664@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "Luke" <luke@ias2001.de>
To: <php-db@lists.php.net>
Sent: Monday, October 08, 2001 10:52 AM
Subject: [PHP-DB] Simple Question, hopefully simple answer
> 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?
mysql_query(select sum(age) as total from table);
maybey you need after the from table the follow rule:
distinc by id.
it is not tested.
success
Jeroen
>
> Hope someone can help.
>
> Luke
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>