我有一个MySQL查询正在执行选择但它没有被执行。 MySQL代码是00000

Question

I have a MySQL query that is doing a select but it is not being executed. The MySQL code is 00000. The code previously worked but now no matter what I change the query to it returns no data. The code is below. Any help on this would be GREATLY appreciated!

$lettersToPrintQuery = "SELECT DISTINCT
                                  Registration.RegNumber, 
                                  Registration.RunnerID
                              FROM 
                                  Registration
                                  LEFT JOIN People On People.RunnerID = Registration.RunnerID
                              WHERE
                                  Registration.CLUBID = :CLUBid
                                  AND
                                  Registration.CLUBDonationLetterNeeded = 1
                              ORDER BY
                                  People.LastName, People.FirstName, People.MI";
        if ($lettersToPrintQuery = $pdoLink->prepare($lettersToPrintSQL))
        {
             error_log("Log prepare");

            $runnersBindValues = "";
            $runnersBindValues[":clubid"] = 19;
            error_log("Bind Parameters: " . json_encode($runnersBindValues));
            if ($lettersToPrintQuery->execute($runnersBindValues))
            {
                error_log("Log execute");
                if ($lettersToPrintQuery->rowCount())
                {
                    error_log("Log row count");
                    $numDonations = $lettersToPrintQuery->rowCount();
                    $_SESSION['RUNNERSAdmin']['Reg']['Donations']['CLUBDonationLettersToPrint'] = array();
                    $_SESSION['RUNNERSAdmin']['Reg']['Donations']['CLUBDonationLettersMailingList'] = array();
                    while ($row = $lettersToPrintQuery->fetch(\PDO::FETCH_ASSOC))
                    {
                        error_log("donation reg numbers inside loop: " . $row["RegNumber"]);
                        error_log("donation runner ids inside loop: " . $row["RunnerID"]);
                        $_SESSION['RUNNERSAdmin']['Reg']['Donations']['CLUBDonationLettersToPrint'][] = $row["RegNumber"];
                        $_SESSION['RUNNERSAdmin']['Reg']['Donations']['CLUBDonationLettersMailingList'][] = $row["RunnerID"];

                    }
                }
            }
            else{
                error_log("Mysql error info: " . json_encode($pdoLink->errorInfo()));
            }
        }
        error_log("Donation reg numbers: " . $_SESSION['RUNNERSAdmin']['Reg']['Donations']['CLUBDonationLettersToPrint']);
        error_log("Donation runner id: " . $_SESSION['RUNNERSAdmin']['Reg']['Donations']['CLUBDonationLettersMailingList']);

error_log("Log execute") is not executing. So it is just not executing

Answer 1

$lettersToPrintQuery = "SELECT DISTINCT

should be:

$lettersToPrintSQL = "SELECT DISTINCT