change:
ORDER BY adid DESC";
to:
ORDER BY ads_horses.adid DESC";
also, in the Data Assist search code block for each of the comparisons:
//comparison list additions
$WADbSearch1->addComparisonFromEdit("adid","adid","AND","=",1);
$WADbSearch1->addComparisonFromEdit("horse_name","horse_name","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_barn_name","horse_barn_name","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_breed_id","horse_breed_id","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_reg_yn","horse_reg_yn","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_reg_assn","horse_reg_assn","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_reg_number","horse_reg_number","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("customerid","customerid","AND","=",1);
$WADbSearch1->addComparisonFromEdit("fldstate","state","AND","=",0);
$WADbSearch1->addComparisonFromEdit("horse_month_foaled","horse_month_foaled","AND","=",0);
$WADbSearch1->addComparisonFromEdit("horse_year_foaled","horse_year_foaled","AND","=",0);
$WADbSearch1->addComparisonFromEdit("horse_gender","horse_gender","AND","=",0);
$WADbSearch1->addComparisonFromEdit("horse_in_foal_yn","horse_in_foal_yn","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_color","horse_color","AND","=",0);
$WADbSearch1->addComparisonFromEdit("horse_hands_high","horse_hands_high","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("horse_skill_id","horse_skill_id","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("sire","sire","AND","=",0);
$WADbSearch1->addComparisonFromEdit("siressire","siressire","AND","=",0);
$WADbSearch1->addComparisonFromEdit("dam","dam","AND","=",0);
$WADbSearch1->addComparisonFromEdit("damssire","damssire","AND","=",0);
if it rtefernaces a column that is in both tables, you will need to edit the code to specofy which table to look in, for example:
$WADbSearch1->addComparisonFromEdit("adid","adid","AND","=",1);
would need to be changed to:
$WADbSearch1->addComparisonFromEdit("ads_horses.adid","adid","AND","=",1);