Error in SQL syntax

I am trying to do a repeat region in the attached php. The section is titled "Latest Inductees". I want to have only the inductees displayed that are in the most recent year only. When I posted the file, the page (http://loyalneighbor.com/index-test.php) only shows "Error in SQL syntax". Can you see how I set the mysqli to do this? I suspect that is where the syntax error is coming from. Y

Open up your rsobj.php file and turn on debugging. It will give you more information about why the query is failing.

sorry, but I have never debugged a rsobj.php page before. how do I turn that on?

Open up the file and you will see a line near the top that says: debug=false

Change it to: debug=true

Thank you Ray, I found the error. I wanted to design the query such that it sorts the "years" in descending order and pulls only the first record when doing that, then it queries all inductees matching that value. The page is now working, except it is returning all inductees in descending year order. I just want those inductees matching the first record in descending order in the "years" table. How can I edit the sql statement to do this? I have MySQLi, but I could not figure it out. The record set I have currently reads as below:

<?php
$catinductee = new WA_MySQLi_RS("catinductee",$PowerCMSConnection_i,1);
$catinductee->setQuery("SELECT inducteecat.cat, inductees.* FROM inducteecat INNER JOIN inductees ON inducteecat.cat = inductees.cat ORDER BY inducteecat.cat ASC, inductees.lastname ASC");
$catinductee->execute();
?>

You would have to add WHERE clause filtered with a parameter to all of the recordsets you want filtered by the first and set the parameter value to the row returned by the first recordset.

That did it. The MySQLi really helps with SQL statements.