2019 Member Agencies

"); echo(" AgencyLocationDirectorWebsite"); //$sql="select * from grpa_department left outer join grpa_member on grpa_member.grpa_department_id = grpa_department.grpa_department_id and grpa_member.grpa_title_id=1 and grpa_member.active=1 where grpa_department.active=1 order by department_name"; //$sql="select * from grpa_department, grpa_member left outer join grpa_member_credential on grpa_member_credential.grpa_member_id = grpa_member.grpa_member_id left outer join grpa_credential_type on grpa_credential_type.grpa_credential_type_id = grpa_member_credential.credential, grpa_member_flag, grpa_member_type_assoc where grpa_member.grpa_department_id = grpa_department.grpa_department_id and grpa_member.grpa_title_id=1 and grpa_member.active=1 and grpa_member.grpa_member_id = grpa_member_flag.grpa_member_id and grpa_member_flag.grpa_member_flag_type_id = 21 and grpa_member_type_assoc.grpa_member_id = grpa_member.grpa_member_id and grpa_member_type_assoc.grpa_member_type_id = 8 order by department_name"; $sql="select * from grpa_department inner join grpa_member on grpa_member.grpa_department_id = grpa_department.grpa_department_id and grpa_member.grpa_title_id=1 and grpa_member.active=1 left outer join grpa_member_credential on grpa_member_credential.grpa_member_id = grpa_member.grpa_member_id left outer join grpa_credential_type on grpa_credential_type.grpa_credential_type_id = grpa_member_credential.credential inner join grpa_member_flag on grpa_member.grpa_member_id = grpa_member_flag.grpa_member_id and grpa_member_flag.grpa_member_flag_type_id = 44 inner join grpa_member_type_assoc on grpa_member_type_assoc.grpa_member_id = grpa_member.grpa_member_id and grpa_member_type_assoc.grpa_member_type_id = 8 where grpa_department.active=1 group by grpa_department.grpa_department_id order by department_name"; /* $sql = "select * from grpa_department left join grpa_member on grpa_member.grpa_department_id = grpa_department.grpa_department_id and grpa_member.grpa_title_id=1 and grpa_member.active=1 left outer join grpa_member_credential on grpa_member_credential.grpa_member_id = grpa_member.grpa_member_id left outer join grpa_credential_type on grpa_credential_type.grpa_credential_type_id = grpa_member_credential.credential left join grpa_member_flag on grpa_member.grpa_member_id = grpa_member_flag.grpa_member_id and grpa_member_flag.grpa_member_flag_type_id = 21 left join grpa_member_type_assoc on grpa_member_type_assoc.grpa_member_id = grpa_member.grpa_member_id and grpa_member_type_assoc.grpa_member_type_id = 8 where grpa_department.active=1 group by grpa_department.grpa_department_id order by department_name"; */ $temp=$mysqli->query($sql); $member_count = 1; while($row = $temp->fetch_array()) { extract($row); $urlvar=''; if ($url != '' && $url != "http://") { $urlvar="Visit Website"; } if ($credential_desc != '') { $credential_desc = ", $credential_desc"; } echo("$member_count$department_name$city, $state$first_name $last_name".$credential_desc."$urlvar"); $member_count++; } echo(""); ?>