#Search Records & Return Found 3 buttons
# 0 Member ID
# 1 Last Name 
# 2 Business Name 
elsif ($action eq "updatetable_167"){
    warn("Entered updatetable_167");
    my $kind = $query->param('kind');
 	my $searchterm = $query->param('searchterm');
	my $result;
	warn("searchterm = '$searchterm'");

    my $searchfield = "";

    if ($kind == 0) {
	  $searchfield = 'user_id';
	} 
	if ($kind == 1) {
	  $searchfield = 'lastname';	
	}
	if ($kind == 2) {
	  $searchfield = 'business';	
	}
	
	warn("searchfield =  '$searchfield'");
		
#    my $stmt = "SELECT * FROM users WHERE $searchfield = ?"; comment out for testing
    my $stmt = "SELECT * FROM users WHERE user_id = 15";

	warn("statement =  '$stmt'");	 #of course meaning nothing with placeholder ?
	
    my $sth = $dbh->prepare ($stmt) or die "Error Preparing:\n" . $stmt . "\nDBI returned: \n", $dbh->errstr;
    
    $sth->execute($searchterm) or die "Unable to execute query: " . $sth->errstr;	
	
	warn("Finished sub search record");	
	
	
	$result = generateResponseHash($sth);
    
#   code # below is used to populate an html table and sent back to the client. Works fine for testing 	
#	$result = generateMemberDataSet($sth);
	
    if ($result == 1) {
      warn("Failed Search: '$searchfield' equal to '$searchterm' "); 
    }  	
}