| TITLE / | $title | ";
echo "| ·········································································································································································································· |
";
if ($row[OrgID]) {
tigconnect("tig");
$org = query("SELECT * FROM tig.Organizations WHERE OrgID = '$row[OrgID]'");
tigdisconnect();
echo "| ORGANIZATION / | ".id2name(org,$row[OrgID])." |
";
echo "| ·········································································································································································································· |
";
if ($org[OrgStatusID]) {
echo "| ORGANIZATION STATUS / | ".id2name(orgstatus,$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 "| PRIMARY CONTACT INFORMATION / | ".$pci." |
";
echo "| ·········································································································································································································· |
";
echo "| REGION / | $region |
";
echo "| ·········································································································································································································· |
";
echo "| 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 " |
";
echo "| ·········································································································································································································· |
";
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 "";
}
echo " |
";
echo "| ·········································································································································································································· |
";
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 " |
";
echo "| ·········································································································································································································· |
";
if ($implement_level) {
echo "| LEVELS OF IMPLEMENTATION / | $implement_level |
";
echo "| ·········································································································································································································· |
";
}
echo "| GUIDING PRINCIPALS / | $guiding_principals |
";
echo "| ·········································································································································································································· |
";
echo "| BACKGROUND AND FOCUS / | $background |
";
echo "| ·········································································································································································································· |
";
echo "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 " |
";
echo "| ·········································································································································································································· |
";
if ($procedure_process) {
echo "| INITIATIVE PROCEDURE / | $procedure_process |
";
echo "| ·········································································································································································································· |
";
} if ($stakeholder) {
echo "| STAKEHOLDERS / Organizations, Groups or Individuals, from different sectors of society, with an interest or role to play in this initiative. | $stakeholder
";
echo "| ·········································································································································································································· |
";
} if ($stakeholder_desc) {
echo "| STAKEHOLDER'S INVOLVEMENT / | $stakeholder_desc |
";
echo "| ·········································································································································································································· |
";
} if ($budget) {
echo "| BUDGET / | $budget |
";
echo "| ·········································································································································································································· |
";
} if ($results) {
echo "| RESULTS AND IMPACT / | $results |
";
echo "| ·········································································································································································································· |
";
} if ($sustainability) {
echo "| SUSTAINABILITY / | $sustainability |
";
echo "| ·········································································································································································································· |
";
} if ($lessons) {
echo "| LESSONS LEARNED / | $lessons |
";
echo "| ································································································································&m································································································································································· |
";
} if ($row["Filename"]) {
?>
| Download
the related file! |
|
