I am sure this is a simple task but I am struggling to make it work. Is there a simple way to totalize a mysql column and display it in the header section of the page?
$result = $g->execute_query(“SELECT SUM(quantity) as s FROM tblestimate where projectnumberest = ‘110902618’”);
You can call:
$rs = $g->get_one(“SELECT SUM(quantity) as s FROM tblestimate where projectnumberest = ‘110902618’”);
$opt[“caption”] = “Sample Grid – “. $rs[“s”];
where $g is new jqgrid() and $opt is variable passed to set_options($opt)
Abu Ghufran - Dev Team
PHP Grid Framework
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!