The Surveillance Lab
" . utf8_decode($row[0]) . "\n");
print("\t
" . utf8_decode($row[1]) . "
\n"); } else print("List of Projects
"); $sql = "SELECT p.project_id, p.project_name, p.description, p.funding, "; $sql .= "p.include_url, p.website_url, p.wiki_url, p.thumbnail_file, p.short_name, "; $sql .= "(p.project_id IN(SELECT pp.project_id FROM projects_pubs as pp)) as has_pubs "; $sql .= "FROM projects as p WHERE active=TRUE "; $sql .= "AND EXISTS (SELECT pt.project_id FROM projects_themes as pt "; $sql .= " WHERE pt.theme_id=$current_theme AND pt.project_id=p.project_id) "; $sql .= "ORDER BY short_name;"; $projects = pg_query($connection, $sql); if (!$projects) { ?>", utf8_decode($row[2]));
$funding = "";
if (strlen($row[3])>0) $funding = "The project is funded by " . utf8_decode($row[3]) . ".";
$imgtag = "";
if (strlen($row[7])>0) $imgtag = "\n";
$weblnktag = "";
if (strlen($row[5])>0) $weblnktag = "\tWebsite\n";
$wikilnktag = "";
if (strlen($row[6])>0) $wikilnktag = "\tWiki\n";
$pubstag = "";
if ($row[9]== "t") $pubstag = "\tPublications\n";
?>
People: Edit "); print(utf8_decode($pers[1]) . " " . utf8_decode($pers[2]) . ""); } while ($pers = pg_fetch_row($peoplelist)) { print(", "); print(utf8_decode($pers[1]) . " " . utf8_decode($pers[2]) . ""); } } ?>
