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();
?>