This topic is locked
[SOLVED]

 get a sum of child record totals on master list page

9/17/2018 1:58:57 PM
PHPRunner General questions
L
laonian author

On the master list page, I have the detail table link and display the total number of child records.


What I want to do is to have a sum of all the child record totals on the master list page. The is shown at the place at the bottom of the extra column for detail links.

M
mersintarim 9/17/2018

master table list page before display event

"select sum(child table field) as total from child table where id='". $_SESSION[$strTableName."_masterkey1"]."'";
and $xt->assign("html_var",total);

L
laonian author 9/17/2018



master table list page before display event

"select sum(child table field) as total from child table where id='". $_SESSION[$strTableName."_masterkey1"]."'";
and $xt->assign("html_var",total);


Thank you very much, mersin tarim.