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. You can use the function as many times as you ...

Right-click the PHP page you want to use to call the stored procedure and select "Open With." Click the PHP editor to open the code. Add the PHP connection to the MySQL database.