Penulisan Query pencarian dan sort data

Assalamualaikum,.. 
code yang saya tulis seperti pada SS yang saya upload :
<?php
                  if($_GET['cari']!=""){
                    $cari = $_GET['cari'];
                    $halaman = 5; //batasan halaman
                    $page = isset($_GET['halaman'])? (int)$_GET["halaman"]:1;
                    $start = ($page>1) ? ($page * $halaman) - $halaman : 0;
                    $result = mysqli_query($koneksi,"SELECT * FROM tbmember WHERE JenisMember='Broker' AND  NamaMember like '".$cari."%'"); 
                    $total = mysqli_num_rows($result);
                    $pages = ceil($total/$halaman);
                    $data = mysqli_query($koneksi,"SELECT * FROM tbmember WHERE JenisMember='Broker' AND NamaMember like '".$cari."%' ORDER BY NamaMember ASC LIMIT $start, $halaman");
                  }else{
                    $halaman = 50; //batasan halaman
                    $page = isset($_GET['halaman'])? (int)$_GET["halaman"]:1;
                    $start = ($page>1) ? ($page * $halaman) - $halaman : 0;
                    $result = mysqli_query($koneksi,"SELECT * FROM tbmember WHERE JenisMember='Broker' ORDER BY NamaMember ASC");
                    $total = mysqli_num_rows($result);
                    $pages = ceil($total/$halaman);
                    $data = mysqli_query($koneksi,"SELECT * FROM tbmember WHERE JenisMember='Broker' ORDER BY NamaMember ASC LIMIT $start, $halaman");
                  }
                    $no=$start+1;
                    while($d = mysqli_fetch_assoc($data)){
                    ?>

Assalamualaikum,.. dilihat dari querynya tidak ada yang salah,
mungkin saya yang kurang paham kasusnya, munkgin bisa diperjelas lagi,
atau share printscreen dari hasil yang sekarang, dan hasil yang diinginkan.