The MySQL SUM function takes the fields or rows you input and adds their values together, then returns the total. Save your query in a PHP variable.

Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query. You must ensure that the table exists before running a query on the table.