query(' SELECT mp.place_name, COUNT(b.biblio_id) AS hasil FROM mst_place AS mp LEFT JOIN biblio AS b ON mp.place_id= b.publish_place_id GROUP BY mp.place_id'); if ($ins_q->num_rows > 0) { while ($institution = $ins_q->fetch_assoc()) { $aut = $institution['place_name']; $r_aut = str_replace(',',' ',$aut); $value = 1; $last_name = implode("", array_slice(explode(" ", $r_aut),0,$value)); echo '
'; echo '
'; echo '
'.$r_aut.' ('.$institution['hasil'].')
'; echo '
'; echo '
'; } } else { echo '

No Librarian data yet

'; }