\n"); ?> MCHI Surveillance Lab :: People

Who we are

The lab is a diverse community of people with backgrounds in epidemiology, public health, microbiology, urban planning, mathematics and computer science. The founder and head of the lab, Dr. David Buckeridge, is an Associate Professor of Epidemiology and Biostatistics at McGill University, where he holds a Canada Research Chair in Public Health Informatics. He is also a medical consultant to the Institut national de sante publique du Quebec and the Direction de sante publique de Montreal.

Add person

0){ $today = getdate(); $offset = $today['yday'] % $num_people; $sql = "SELECT person_id, first_name, last_name, position, bio, website_url, include_url, "; $sql .= "picture_file, former, (person_id IN(SELECT person_id FROM people_pubs)) as has_pubs "; $sql .= "FROM people WHERE active=TRUE AND former=FALSE ORDER BY person_id OFFSET $offset;"; $people = pg_query($connection, $sql); if ($people) { $row = pg_fetch_row($people); $pid = $row[0]; $fname = utf8_decode($row[1]); $lname = utf8_decode($row[2]); $position = utf8_decode($row[3]); $bio = str_replace(array("\r\n", "\n", "\r"), "

", utf8_decode($row[4])); $imgtag = ""; if (strlen($row[7])>0) $imgtag = "\"$fname\n"; $weblnktag = ""; if (strlen($row[5])>0) $weblnktag = "Website\n"; $pubstag = ""; if ($row[9]== "t") $pubstag = "Publications\n"; ?>

Person of the day:

Current projects:"); print(" " . utf8_decode($proj[0]) . ""); while ($proj = pg_fetch_row($projlist)) { print(", " . utf8_decode($proj[0]) . ""); } print("

\n"); } } $sql = "SELECT pr.short_name, pr.project_name, pr.project_id, MIN(t.theme_id) "; $sql .= "FROM projects as pr, projects_people as pp, research_themes as t, projects_themes as pt "; $sql .= "WHERE pr.project_id=pp.project_id AND pp.person_id=$pid AND pr.active=FALSE "; $sql .= " AND pr.project_id=pt.project_id AND t.theme_id=pt.theme_id "; $sql .= "GROUP BY pr.short_name, pr.project_name, pr.project_id ORDER BY pr.short_name;"; $projlist = pg_query($connection, $sql); if ($projlist) { if ($proj = pg_fetch_row($projlist)) { print("

Past projects:"); print(" " . utf8_decode($proj[0]) . ""); while ($proj = pg_fetch_row($projlist)) { print(", " . utf8_decode($proj[0]) . ""); } print("

\n"); } } ?>

Home Logout Change password Login