Select and add values of field - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

proctor · 11-10-2005, 08:09 PM

In this MySQL database each record has a visit_field that is an integer value.

How do I total and return values of the visit_field?

For example, if record 1 has a visit_field value of 8 and record 2 has a visit_field with a value of 10, I want to return 18.

I've been trying

to figure this out but have ot been successfull. Tia

econ · 11-12-2005, 01:04 PM

Have you tried using Sum....

Code:

SELECT SUM( visit_field ) FROM database;