I have below code to populate items from basket table. I want to know is it possible to calculate the item_quantity TD and show the total_sum or I should do it at MySQL level?

Thanks,

Jassim Rahma

2. <div id="divBasket" style="background-color: #FFFFFF; margin-top: 50px; margin-right: 120px; border: 1px solid; border-radius: 25px; padding: 10px; width: 300px; float: right;">
3. <table width="100%" cellspacing="10">
4. <?php
5. $session_id = $_SESSION["id"];
6.     $mysql_query = $mysql_connection->prepare('CALL sp_populate_basket_items(:param_session_id)');
7. $mysql_query->bindParam(':param_session_id', $session_id, PDO::PARAM_STR);
8.     $mysql_query->execute();
9. 
   
10.     while($mysql_row = $mysql_query->fetch())
11.     {
12. ?>
13. <tr>
14. <td class="item_name"><?php echo $mysql_row["item_name"]; ?></td>
15.     <td class="item_quantity"><?php echo $mysql_row["item_quantity"]; ?></td>
16.     <td class="item_price"><?php echo $mysql_row["item_price"]; ?></td>
17. </tr>
18. <?php } ?>
19. <tr>
20. <td colspan="3"><hr></td>
21. </tr>
22. <tr>
23. <td align="right">Total :</td>
24.     <td></td>
25.     <td>TOTAL_SUM_FROm_JQUERY</td>
26. </tr>
27. <tr>
28. <td align="center" colspan="3"><img src="images/buy_now.png"></td>
29. </tr>
30. </table>
31. </div>