«  Return to Lessons Learned Projects Fact Sheets "; if ($row[OrgID]) { tigconnect("tig"); $org = query("SELECT * FROM tig.Organizations WHERE OrgID = '$row[OrgID]'"); tigdisconnect(); echo ""; if ($org[OrgStatusID]) { echo ""; } } if ($org[Email]) { $pci .= "E: $org[Email] "; } if ($org[Phone]) { $pci .= "P: $org[Phone] "; } if ($org[Fax]) { $pci .= "F: $org[Fax] "; } if (!$row[OrgID]) { $pci = $row[ContactInfo]; } echo ""; echo ""; echo ""; echo ""; echo ""; if ($implement_level) { echo ""; } echo ""; echo ""; echo ""; if ($procedure_process) { echo ""; } if ($stakeholder) { echo "$stakeholder"; } if ($stakeholder_desc) { echo ""; } if ($budget) { echo ""; } if ($results) { echo ""; } if ($sustainability) { echo ""; } if ($lessons) { echo ""; } if ($replication) { echo ""; } echo ""; if ($row["Filename"]) { ?> Title: $title Organization: ".id2name(org,$row[OrgID])." Organization Status: ".id2name(orgstatus,$org[OrgStatusID])." Primary Contact Information: ".$pci." Region: $region Target Age Group(s): "; $sql = "SELECT age "; $sql .= "FROM tigsm_yes.age AS a INNER JOIN tigsm_yes.inititive_age AS ia ON a.id = ia.age_id "; $sql .= "WHERE ia.inititive_id = '$pid'"; $sql_result = mysql_query($sql) or die(mysql_error()); while ($ageRow = mysql_fetch_array($sql_result)) { $age = $ageRow["age"]; echo "$age "; } echo " Special Groups Focus: "; $sql = "SELECT special_group "; $sql .= "FROM tigsm_yes.special_group AS sg INNER JOIN tigsm_yes.inititive_group AS ig ON sg.id = ig.group_id "; $sql .= "WHERE ig.inititive_id = $pid"; $sql_result = mysql_query($sql); while ($spRow = mysql_fetch_array($sql_result)) { $group = $spRow["special_group"]; echo "$group "; } echo " Thematic Area: "; $sql = "SELECT thematic "; $sql .= "FROM tigsm_yes.thematic AS t INNER JOIN tigsm_yes.inititive_thematic AS it ON t.id = it.thematic_id "; $sql .= "WHERE it.inititive_id = $pid"; $sql_result = mysql_query($sql); while ($thematicRow = mysql_fetch_array($sql_result)) { $thematic = $thematicRow["thematic"]; echo "$thematic "; } echo " Levels of Implementation: $implement_level Guiding Principals: $guiding_principals Background and Focus: $background Overcoming Barriers: Obstacles this initiative aims to address. "; $sql = "SELECT barrier "; $sql .= "FROM tigsm_yes.barrier AS b INNER JOIN tigsm_yes.inititive_barrier AS ib ON b.id = ib.barrier_id "; $sql .= "WHERE ib.inititive_id = $pid"; $sql_result = mysql_query($sql); while ($barrierRow = mysql_fetch_array($sql_result)) { $barrier = $barrierRow["barrier"]; echo "$barrier "; } echo " Initiative Procedure: $procedure_process Stakeholders: Organizations, Groups or Individuals, from different sectors of society, with an interest or role to play in this initiative. Stakeholders' Involvement: $stakeholder_desc Budget: $budget Results and Impact: $results Sustainability: $sustainability Lessons Learned: $lessons Potential for Replication: $replication Areas of Focus (topics): "; $sql = "SELECT focus "; $sql .= "FROM tigsm_yes.focus AS f INNER JOIN tigsm_yes.inititive_focus AS i_f ON f.id = i_f.focus_id "; $sql .= "WHERE i_f.inititive_id = $pid"; $sql_result = mysql_query($sql); while ($focusRow = mysql_fetch_array($sql_result)) { $focus = $focusRow["focus"]; echo "$focus "; } echo " Download the related file!