this line:
$WADbSearch1->addComparisonFromList("spell_class","S_spell_class","AND","Includes",0);
is creating a search criteria using a column named "spell_class".
in your origianl description of the database:
spell_id
spell_name
spell_class_id
spell_level
I also have a table that contains every class:
class_id
class_name
you do not mention a column named "spell_class", nor is there a column named "spell_class" returned from your recordset:
SELECT
spell.spell_class_id,
spell.spell_name,
class.class_name,
spell.spell_level,
class.class_id
FROM
spell
Inner Join class ON spell.spell_class_id = class.class_id
did you mean to use "class_name" instead?
$WADbSearch1->addComparisonFromList("class_name","S_spell_class","AND","Includes",0);
or spell_class_id?
$WADbSearch1->addComparisonFromList("spell_class_id","S_spell_class","AND","Includes",0);