ok, so i figured out how to get the grand total on the manage_entries.php code.
Here it is:
//get price column total
$query = "SELECT * FROM ".MF_TABLE_PREFIX."form_{$form_id}";
$params = array();
$sth = mf_do_query($query,$params,$dbh);
while ($row = mf_do_fetch_result($sth)) {
$totalPrice += $row['element_5'];
}
What Im wondering now is there a way to have the $totalPrice show an updated total when I choose filter items?
This code still shows grand total of all items and not total of filtered items? Any help?