[RESOLVED] Is there a mySQL function within the SELECT query....

[contrasites]

Hello Coders,

Is there a mySQL function within the SELECT query that can add all of the data within a field.

For example if I have a table called "profiles" and a field within that table called "referals" (which is an integer) and I wanted to add all of the results within that field together...

I was trying to think of a loop to write this code in and may still do it but was wondering if there is a function within the SELECT statement that can ADD all of them together.

Thanks in advanced for your help!

B/E/N/

[shu]

SELECT SUM/b AS tot FROM profiles; 😃

[contrasites]

....ah NICE! , I thought there had to be something like that, saves me allot of time!

Thanks!