Uploaded with
ImageShack.usI need urgent help sum column rodape tried the example but could not make it work please if someone could post an example I thank,
SOURCE CODE BELOW USED
<table id="dg" title="IMPERIO SOFTWARE" class="easyui-datagrid" style="width:900px;height:450px"
url="troca_fazope01.php"
toolbar="#toolbar"
pagination="true"
rownumbers="true"
fitColumns="true"
singleSelect="true"
pageSize="20"
showFooter="true">
<thead>
<tr>
<th field="bomparB" width="50" sortable="true" align="left">Bom para</th>
<th field="fantasB" width="50" align="left">PRODUTO</th>
this column to sum----><th field="salemiB" width="50" align="left">VALOR</th>
</tr>
</thead>
</table>
<!-------------------------------------------->
FILE troca_fazope01.php
session_start();
$cCodope=$_SESSION["cCodope"];
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
$offset = ($page-1)*$rows;
$result = array();
include_once('conn.php');
mysql_query ( "SET NAMES 'utf8'" ); //PARA CARREGAR COM ACENTOS
$rs = mysql_query("SELECT count(*) from tab_entche WHERE seqlotB='$cCodope' ") or die (mysql_error ());
$row = mysql_fetch_row($rs);
$result["total"] = $row[0];
$rs = mysql_query("SELECT date_format(bomparB,'%d/%m/%Y') as bomparB,fantasB,salemiB FROM tab_entche WHERE seqlotB='$cCodope' limit $offset,$rows")
or die (mysql_error ());
$items = array();
while($row = mysql_fetch_object($rs)):
array_push($items, $row);
endwhile;
$result["rows"] = $items;
echo json_encode($result);
<!---------------------------------------->