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 '
No Librarian data yet
'; }