query 1

<td bgcolor="#6699ff">JUMLAH</td>
<?php
$sql= <<<QUERY
SELECT
  (
    h_pns.j_panitia+h_pns.j_pengelola+h_nonpns.j_pegawai+h_nonpns.j_pengelola
    +b_pns.jt
    +bbph.j_batk+bbph.j_bale+bbph.j_bpm+bbph.j_bpk+bbph.j_bbb+bbph.j_bbu+bbph.j_bpc+bbph.j_bkk
    +bbm.j_bbpp+bbm.j_bboo+bbm.j_bbk+bbm.j_bbd+bbm.j_bbpb+bbm.j_bpd+bbm.j_bbpk
    +bjk.j_bt+bjk.j_ba+bjk.j_bl+bjk.j_bs+bjk.j_bk+bjk.j_bjm+bjk.j_bjt+bjk.j_bjp
    +bpkb.j_bjs+bpkb.j_bbb
    +bcp.j_bc+bcp.j_bp
    +bssm.j_bd+bssm.j_ba
    +bmm.j_hp+bmm.j_r+bmm.j_t+bmm.j_k
    +bpk.j_p+bpk.j_l
    +bpkht.j_d+bpkht.j_p
    +bpd.j_d+bpd.j_l
    +bp.j_gk+bp.j_pp+bp.j_kj+bp.j_pp+bp.j_al+bp.j_ab+bp.j_aas+bp.j_tp+bp.j_ak+bp.j_as
    +modperlkan.j_tik+modperlkan.j_gen+modperlkan.j_ol
    +tbmodperkan.j_al+tbmodperkan.j_bra+tbmodperkan.j_fil+tbmodperkan.j_ac
  ) As jumlah
FROM
  akun
  JOIN h_pns ON h_pns.id_s=akun.id
  JOIN h_nonpns ON h_nonpns.id_s=akun.id
  JOIN b_pns ON b_pns.id_s=akun.id
  JOIN bbph ON bbph.id_s=akun.id
  JOIN bbm ON bbm.id_s=akun.id
  JOIN bjk ON bjk.id_s=akun.id
  JOIN bpkb ON bpkb.id_s=akun.id
  JOIN bcp ON bcp.id_s=akun.id
  JOIN bssm ON bssm.id_s=akun.id
  JOIN bmm ON bmm.id_s=akun.id
  JOIN bpk ON bpk.id_s=akun.id
  JOIN bpkht ON bpkht.id_s=akun.id
  JOIN bpd ON bpd.id_s=akun.id
  JOIN bp ON bp.id_s=akun.id
  JOIN modperlkan ON modperlkan.id_s=akun.id
  JOIN tbmodperkan ON tbmodperkan.id_s=akun.id
WHERE
  akun.kat='TK'
ORDER BY akun.id ASC
QUERY;

$s1=mysql_query($sql);
while($r1=mysql_fetch_array($s1))
{
echo "<td bgcolor='#6699ff'>Rp.{$r1['jumlah']}</td>";
}
?>
</tr>
</table>