Hello
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’”);
thank you
Tony
2 Answers
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)
Your Answer