Thanks Ray
I get:
SELECT `pages`.`PgID`, `pages`.`PgTypeID`,`pages`.`PgBriefDetails`,`pages`.`PgMainPic`, `pages`.`PgMainPicAltText`, pages.StartDate, pages.EndDate, DATE_FORMAT (pages.StartDate ,'%a %D %b %Y') AS `StartDateA`, DATE_FORMAT (pages.EndDate ,'%a %D %b %Y') AS `EndDateA`, `pages`.`Active`, `pages`.`PgSticky`, `pages`.`MemOnly`, `pages`.`PgTitle`, `pagetypes`.`PageType`, `p2a`.`PgTitle` AS `UnderPageTitle`, Count(distinct `sub-pages`.`PgID`) AS `SubPages`, Count(distinct comments.`CmID`) AS `comments`, `pages`.`Under_PgID`, CONCAT_WS (' ',rotarians.FirstName, rotarians.Surname) AS `Author`, CONCAT (LEFT (`rotarians` .`FirstName` ,1), LEFT(`rotarians` .`Surname` ,1)) AS `Authinitials`, Count(distinct`pageimages`.`PicID`) AS `Slideshow`, pages.MODisplay, pages.PgDesc, Count(distinct`pageforms`.`FormID`) AS FormID FROM `pages` Inner Join `pagetypes` ON `pagetypes`.`PgTypeID` = `pages`.`PgTypeID` Left Join `pages` AS `p2a` ON `pages`.`Under_PgID` = `p2a`.`PgID` Left Join `pages` AS `sub-pages` ON `sub-pages`.`Under_PgID` = `pages`.`PgID` Left Join `comments` ON `pages`.`PgID` = `comments`.`PgID` Left Join `rotarians` ON `pages`.`Pg_RotID` = `rotarians`.`RotID` Left Join `pageimages` ON `pages`.`PgID` = `pageimages`.`PgID` Left Join `pageforms` ON `pages`.`PgID` = `pageforms`.`PgID` WHERE (`pages`.`ClubID` = ?) AND `pages`.`DistrictNo` IS NULL AND ((`PgTypeID` = ?)) GROUP BY `pages`.`PgID` ORDER BY `pages`.`StartDate` ASC, `pages`.`PgID` DESC
Column 'PgTypeID' in where clause is ambiguous
-------------
However, PgTypeID isn't in my WHERE clause in my recirdset - is this altered by the search? If so, where would I specify pages.PgTypeID?
Would it be on this line - ?
$searchWADApage1->setSearch(array("type"=>"Edit", "comparison"=>"=", "join"=>"AND"), array("PgTypeID"), "d", "PgTypeID");
Thanks again for your help.
Chris