Sumar td de una consulta no se si me explique pero dejo el codigo de ambas partes y pidu ideas agracias.
Código PHP:
#Checar que el usuario provenga de la pagina indicada
require ("_cls/cls_Control_Sess.php");
$isInit = new Control_Sess();
$isInit->checkAuth();
unset($isInit);
//Getting lists
require ("_cls/cls_mysqlData.php");
require ("_cls/cls_ReporteII.php");
$rptReporte = new Reporte();
$rpt = $rptReporte->rptstatus();
?>
<script language="javascript" type="text/javascript">
</script>
<table class="tableData" id="Data" border="1">
<thead id="thead">
<tr>
<th rowspan="2">DDR</th>
<th colspan="3">AGRICOLA</th>
<th colspan="3">PECUARIO</th>
<th colspan="3">DES. RURAL</th>
<th colspan="3">ACUACULTURA Y PESCA</th>
<th colspan="3">COUSSA</th>
<th colspan="3">RECONVERSION</th>
</tr>
<tr>
<th>SOLICITUDES RECIBIDAS</th>
<th>SOLICITUDES PAGADAS</th>
<th>MONTO PAGADO</th>
<th>SOLICITUDES RECIBIDAS</th>
<th>SOLICITUDES PAGADAS</th>
<th>MONTO PAGADO</th>
<th>SOLICITUDES RECIBIDAS</th>
<th>SOLICITUDES PAGADAS</th>
<th>MONTO PAGADO</th>
<th>SOLICITUDES RECIBIDAS</th>
<th>SOLICITUDES PAGADAS</th>
<th>MONTO PAGADO</th>
<th>SOLICITUDES RECIBIDAS</th>
<th>SOLICITUDES PAGADAS</th>
<th>MONTO PAGADO</th>
<th>SOLICITUDES RECIBIDAS</th>
<th>SOLICITUDES PAGADAS</th>
<th>MONTO PAGADO</th>
</tr>
</thead>
<tbody id="rows" align="left">
<?php
if ($rpt <> ""){echo $rpt;}
else{echo '<tr><td colspan="19">No hay Registros</td></tr>';}
?>
</tbody>
<tr>
<td>Totales</td>
<td id="demosum2">aqui me gustaria desplegar las suma de la columna respectiva</td>
<td id="demosum3"></td>
<td id="demosum4"></td>
<td id="demosum5"></td>
<td id="demosum6"></td>
<td id="demosum7"></td>
<td id="demosum8"></td>
<td id="demosum9"></td>
<td id="demosum10"></td>
<td id="demosum11"></td>
<td id="demosum12"></td>
<td id="demosum13"></td>
<td id="demosum14"></td>
<td id="demosum15"></td>
<td id="demosum16"></td>
<td id="demosum17"></td>
<td id="demosum18"></td>
<td id="demosum19"></td>
</tr>
</table><br /><br /> Código PHP:
?php
class Reporte{
//acontinuacion sacaremos el reporte de consentrado por componente
public function rptstatus(){
$rptCon = '';
$db = new db();
$rpt = '';
$rpt2 = '<td>0</td>';
$rpt3 = '<td>0</td>';
$rpt4 = '<td><span style="float:left;">$</span>0.00</td>';
//primero sacaremos el listado de beneficios que tenga la organizacion
$result = $db->query("SELECT DISTINCT idddr, ddr FROM solicitudes ORDER BY idddr DESC");
while ($Arrdet = $db->fetch_array($result)){
unset($rpt);
$idddr = $Arrdet["idddr"];
$ddr = $Arrdet["ddr"];
$idcom = 1;
while ($idcom <= 6){
//a sacamos el total de solicitudes
$NoFolios = $db->query("SELECT count( `Folio Estatal` ) AS No FROM solicitudes WHERE idcomponente = ".$idcom." and idddr = ".$idddr."");
$Arr2 = $db->fetch_array($NoFolios);
if($Arr2["No"] <> 0 || $Arr2["No"] <> NULL){
$rpt2 = '<td>'.$Arr2["No"].'</td>';
}
else{$rpt4 = '<tdalign="right"><span style="float:left;">$</span>0.00</td>';}
//consulta para obtenr los solicitudes apolladas
$NoFolPag = $db->query("SELECT count( `Folio Estatal` ) AS NoCon FROM solicitudes WHERE idcomponente = ".$idcom." and idddr = ".$idddr." and `Apoyo (Comprometido)` <> 0");
$Arr3 = $db->fetch_array($NoFolPag);
if($Arr3["NoCon"] <> 0 || $Arr3["NoCon"] <> NULL){
$rpt3 = '<td>'.$Arr3["NoCon"].'</td>';
}
else{$rpt4 = '<tdalign="right"><span style="float:left;">$</span>0.00</td>';}
//consulta para el monto de las solicitudes dictaminadas
$NoMonto = $db->query("SELECT sum( `Apoyo (Comprometido)` ) AS monto FROM solicitudes WHERE idcomponente = ".$idcom." and idddr = ".$idddr." and `Apoyo (Comprometido)` <> 0");
$Arr4 = $db->fetch_array($NoMonto);
if($Arr4["monto"] <> 0 || $Arr4["monto"] <> NULL){
$rpt4 = '</td><td align="right"><span style="float:left;">$</span>'.number_format($Arr4["monto"], 2, '.',',').'</td>';
}
else{$rpt4 = '<td align="right"><span style="float:left;">$</span>0.00</td>';}
$rpt .= $rpt2.$rpt3.$rpt4;
unset($rpt2,$rpt3,$rpt4);
$idcom++;
}
$rptCon .='<tr><td>'.$idddr.', '.$ddr.'</td>'.$rpt.'</tr>';
}
unset($db, $result, $Arrdet, $Arr2, $Arr3, $Arr4);
return ($rptCon);
}
}
?>
