Easy SQL Q for the pros

zetec452 · 1 May 2007 at 13:07

Hey,

I'm struggling to find the function or SQL command that will add up values (prices) in Php and MySQL.

I've be grateful if some kind sould could point me in the right direction.

Cheers,

Jon

SoapSurgeon · 1 May 2007 at 13:09

SUM ?

look here

zetec452 · 1 May 2007 at 13:10

I tried SUM earlier but can't have been using it correctly.

Time for a cup of tea and brain transplant

.

zetec452 · 1 May 2007 at 13:13

Yep, I was using the query incorrectly.

http://groups.google.co.uk/group/co...=st&q=mysql+sum&rnum=3&hl=en#0253707cc5c470c7

has a decent explination

.