Hi Eric,
Thanks for getting back to me.
This is my recordset as i tried doing what you said but it did not work:
SELECT clients.ClientID, clients.DateCreated, clients.App1Title, clients.App1FirstName, clients.App1LastName, clients.App1DOB, clients.App1Email, clients.App1House, clients.App1Street, clients.App1County, clients.App1City, clients.App1Zip, clients.App1Country, clients.App1Phone, clients.App1Mob, clients.InitialEnquiry, clients.Status, clients.ClientUserID, clients.referredby_RefID, clients.App2Title, clients.App2FirstName, clients.App2LastName, clients.App2DOB, clients.App2Email, clients.App2Phone, clients.App2Mob, clients.App2House, clients.App2Street, clients.App2City, clients.App2Zip, clients.App2Country, DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(App1DOB, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(App1DOB, '00-%m-%d')) AS App1Age, DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(App2DOB, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(App2DOB, '00-%m-%d')) AS App2Age FROM clients ORDER BY clients.App1LastName"
Data assist search code from page:
$WADbSearch1->keywordComparison($KeyArr0,"".((isset($_POST["LastName"]))?$_POST["LastName"]:"") ."","AND","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->addComparisonFromEdit("App1DOB","StartDOB","OR",">=",2);
$WADbSearch1->addComparison("App1DOB","".WAQB_getEndDate($_POST["EndDOB"]) ."","AND","<=",2);
$WADbSearch1->addComparisonFromEdit("App1Age","Age","OR","=",1);
$WADbSearch1->keywordComparison($KeyArr1,"".((isset($_POST["City"]))?$_POST["City"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
$WADbSearch1->keywordComparison($KeyArr2,"".((isset($_POST["Zip"]))?$_POST["Zip"]:"") ."","OR","Includes",",%20","%20","%22","%22",0);
this does not work, so not sure how to have it search the age.
everything else works except the date format which i have another post on.
if you could help asap i would appreciate as need to get this search page finished.
many thanks