WHERE clause in query not working

[ryntak4536]

Hello all,

 

Newbie here...

This WHERE clause in the query of this function is not working, but I cannot figure out why:

    function find_author_list($author_intial){
        global $connection;
        //Perform author query
        $query =     "SELECT * ";
        $query .=     "FROM authors ";
        $query .=    "WHERE Last_Name LIKE \"{$author_initial}%\" ";
        $query .=    "ORDER BY Last_Name ASC";
        $author_set = mysqli_query($connection, $query);
        //test if there was a query error
        confirm_query($author_set);
        return $author_set;
    }

I'm calling it with

$author_set = find_author_list($current_initial);

And instead of limiting it to the initial passed to it, it's returning ALL of the authors in my database.

I've included an echo at the top of my page to show me what $current_initial is, and it's clearly a single letter.

 

Any help is appreciated!

[ryntak4536]

NEVERMIND!

 

I just found my error!