query($sql); if($sql->numRows() > 0){ echo ''; echo ''; foreach($sql->fetchAll() as $data){ $j = str_replace('.','_',$data['kode_tindakan']); echo ''; } echo '

Nama Tindakan	Tarif	Dokter	Aksi
'.$data['nama_tindakan'].'	'.format_uang($data['tarif']).'	'; $sqld = $db->query('select a.*, b.NAMADOKTER from m_dokter_pengganti a join m_dokter b on b.KDDOKTER = a.kddokter'); if($sqld->numRows() > 0){ echo ''; foreach($sqld->fetchAll() as $d){ echo ''.$d['NAMADOKTER'].''; } echo ''; } echo '

'; } } ?>