Adding variables within an array

[Anon]

I have a dbase i want to add the contents of one entire column (Price column) to create a total price. What is the best way to do it? (Yes, I am new to php and programming in general)

Thanks!

[lawnmowerman]

Most databases support the sum() function. Try a query like this:

SELECT SUM(Price) as TotalPrice from DBName;

This will return a single result labeled as TotalPrice with the summation of the entire column.

Hope this helps!

-Rich