Table no. search by Last Name

get_results( “SELECT * FROM HKUAAOLN WHERE lastname =” . $HKUAAOLASTNAME);
$HKUAAO_result = $wpdb->get_results(
$wpdb->prepare(“SELECT * FROM HKUAAOLN WHERE lastname =%s”,$HKUAAOLASTNAME));
echo ‘

';
    $line_output = str_replace(',', '
',$HKUAAO_result [0] -> hkuaaoinfo);
    $finalrecord = str_replace(';', '

',$line_output);
    //print_r($HKUAAO_result);
    print_r($finalrecord);
    echo '

‘;
}
?>

Last Name: