Search related to results
Hi.
I have a table of people and a table of relation. The relation table has people_id, relation_id, related_people_id.
The relation table tells me who is related to who "people_id" is related to "related_people_id" and how they are related, defined by "relation_id".
The search currently shows me people who have the relation_id that matches my selection.
I'd like to search by all this criteria and then show people related to the results. Ex: search for every person with the relation_id of mom of a person 13-18yrs old.
Any ideas? I'd appreciate the help.
Recordset:
mysql_select_db($database_MinistryPro, $MinistryPro);
$query_rs_people = "SELECT people.people_id, people.people_status, people.people_profilepic, people.people_first_n, people.people_last_n, people.people_gender, people.people_birthdate, people.people_grade, people.people_address, people.people_address_2, people.people_city, people.people_state, people.people_zip, people.people_phone_number, people.people_phone_number_alt_1, people.people_phone_number_alt_2, people.people_txt_provider_id, people.people_txt_on_off, people.people_email, people.people_email_alt_1, people.people_email_alt_2, people_tag.tag_id, tag.tag_title, people_step.people_step_id, people_step.step_id, people_place.place_id, place.place_title, people_relation.people_relation_id, people_relation.relation_id, people_relation.related_people_id
FROM people
LEFT JOIN people_tag ON (people.people_id = people_tag.people_id)
LEFT JOIN tag ON (people_tag.tag_id = tag.tag_id)
LEFT JOIN people_place ON (people.people_id = people_place.people_id)
LEFT JOIN place ON (people_place.place_id = place.place_id)
LEFT JOIN people_step ON (people.people_id = people_step.people_id)
LEFT JOIN people_relation ON (people.people_id = people_relation.related_people_id)
LEFT JOIN relation ON (people_relation.relation_id = relation.relation_id)
GROUP BY people.people_id, people_tag.people_id, people_step.people_id, people_place.people_id";
setQueryBuilderSource($query_rs_people,$WADbSearch1,false);
$rs_people = mysql_query($query_rs_people, $MinistryPro) or die(mysql_error());
$row_rs_people = mysql_fetch_assoc($rs_people);
$totalRows_rs_people = mysql_num_rows($rs_people);
Comparison list:
//comparison list additions
$WADbSearch1->addComparison("people_first_n","".((isset($_POST["first_name"]))?$_POST["first_name"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_last_n","".((isset($_POST["last_name"]))?$_POST["last_name"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_gender","".((isset($_POST["button-radio"]))?$_POST["button-radio"]:"") ."","AND","=",0);
$WADbSearch1->addComparisonFromList("people_marital_status","marital_status","AND","=",0);
$WADbSearch1->addComparison("people_birthdate","".$min_birthdate ."","AND","<=",2);
$WADbSearch1->addComparison("people_birthdate","".$max_birthdate ."","AND",">=",2);
$WADbSearch1->addComparison("people_address","".((isset($_POST["address"]))?$_POST["address"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_address_2","".((isset($_POST["address_2"]))?$_POST["address_2"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_city","".((isset($_POST["city"]))?$_POST["city"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_state","".((isset($_POST["state"]))?$_POST["state"]:"") ."","AND","=",0);
$WADbSearch1->addComparison("people_zip","".((isset($_POST["zip"]))?$_POST["zip"]:"") ."","AND","=",1);
$WADbSearch1->addComparison("people_phone_number","".((isset($_POST["area_code"]))?$_POST["area_code"]:"") ."".((isset($_POST["phone_number"]))?$_POST["phone_number"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_email","".((isset($_POST["email"]))?$_POST["email"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("people_grade","".((isset($_POST["grade_min"]))?$_POST["grade_min"]:"") ."","AND","<=",2);
$WADbSearch1->addComparison("people_grade","".((isset($_POST["grade_max"]))?$_POST["grade_max"]:"") ."","AND",">=",2);
$WADbSearch1->addComparisonFromList("people_place.place_id","place","AND","=",0);
$WADbSearch1->addComparisonFromList("people_tag.tag_id","tags","AND","=",0);
$WADbSearch1->addComparisonFromList("people_status","status","AND","=",0);
$WADbSearch1->addComparison("step_id","".$steps_array ."","AND","=",0);
$WADbSearch1->addComparisonFromList("people_relation.relation_id","relation","AND","=",0);