multipling rows

[Anon]

I want to loop th a mysql table and extract a row ie. price take the value for how amny rows then add them together to get one sum

can someone help on this
TIA
Richie TM

[steved]

Don't know for sure about mysql, but most sql languages support the SUM function in a select statement. As long as your column is defined as numeric, you can do something like:

SELECT SUM(column_name)
FROM table_name
WHERE blah, blah, blah.....