k.satuan_kerja_tujuan) AND COALESCE(s.tahun,'') <> 'batal' AND k.proses_tu IS NULL AND s.jenis_surat_id='3' AND s.jenis_disposisi_id='3' AND k.lama IS NOT NULL "); while ($r = pg_fetch_array($data)) { $j = $r[0]; } echo $j;