Sum of field contents... ???

[Anon]

First off... Thanks to those of you that helped yesterday. Appreciate it.

How do I sumarize a fields contents from all records returned from a select statement... IN PHP?

Exp.

two records returned with a column called 'visits'...

one record has 20 in the visits column and the other has 30

HOW can I get PHP to add up THIS COLUMN in those two records? ??

Fritz
Webcrafter
Witchvox.com

[[deleted]]

i don't know if you mean this, but try this sql command:

$sql = "SELECT sum(visits) FROM yourtablename";

this should sum up all the content (supposedly interger values) and return it to you, when you use the resource id of $result and call a mysql function to grab the value ...

hope that was the thing you wanted to do, otherwise post again.

ali