Research

Contact Us


Satinder S. Baveja, Director
3749 Beyster Bldg.
Ann Arbor, MI 48109-2121
PH: 734-936-2831
baveja@eecs.umich.edu


Kimberly Mann
Research Proc. Coordinator
3820 Beyster Building
Ann Arbor, MI 48109-2121
PH: 734-763-6985
Fax: 734-763-1260
kimrmann@umich.edu

0) { $sql = "SELECT * FROM research WHERE research_id = " . $r_id; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $testr_id = $row["research_id"]; } if(!$testr_id) { echo "Record not found in table."; finish(); } $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $research_id = $row["research_id"]; $research_name = $row["research_name"]; } } //Get info for selected research group if($g_id > 0) { $sql = "SELECT * FROM resgroup WHERE resgroup_id = " . $g_id; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $testg_id = $row["resgroup_id"]; } $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $resgroup_id = $row["resgroup_id"]; $resgroup_name = $row["resgroup_name"]; $resgroup_description = $row["resgroup_description"]; $resgroup_url = $row["resgroup_url"]; $resgroup_photo = $photo = $row["resgroup_photo"]; } $resgroup_photo = "\"form"; //Get faculty $faculty_found = ''; $sql = "SELECT * FROM group2 " . "INNER JOIN person ON group2.person_id=person.person_id " . " " . "AND group2.resgroup_id = " . $resgroup_id . " " . "ORDER BY person.lastname, person.firstname"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $eecs_url = "https://www.eecs.umich.edu/eecs/etc/fac/facsearchform.cgi?" . $row["uniqname"] . "+"; if($row["url"]) { $faculty_found .= "" . $row["lastname"] . ", " . $row["firstname"] . " " . $row["middlename"] . "
"; } else { $faculty_found .= "" . $row["lastname"] . ", " . $row["firstname"] . " " . $row["middlename"] . "
"; } } //Get related labs, centers, and groups from other2 n-m table $others_found = ''; $sql = "SELECT * FROM other2 " . "INNER JOIN resother ON other2.resother_id=resother.resother_id " . " " . "AND other2.other2_type = 2 AND other2.match_id = " . $resgroup_id . " " . "ORDER BY resother.resother_name"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { if($row["resother_url"]) { $others_found .= "" . $row["resother_name"] . "
"; } else { $others_found .= $row["resother_name"] . "
"; } } //Get affiliated faculty $people_found = ''; $sql = "SELECT * FROM people2 " . "INNER JOIN respeople ON people2.respeople_id=respeople.respeople_id " . " " . "AND people2.people2_type = 2 AND people2.match_id = " . $resgroup_id . " " . "ORDER BY respeople.respeople_lname, respeople.respeople_fname"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { if($row["respeople_url"]) { $people_found .= "" . $row["respeople_lname"] . ", " . $row["respeople_fname"] . "
"; } else { $people_found .= $row["respeople_lname"] . ", " . $row["respeople_fname"] . "
"; } } //Get research projects $resprojects_found = ''; $sql = "SELECT * FROM resproject WHERE resgroup_id = " . $resgroup_id . " ORDER BY resproject_name"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $resproject_id = $row["resproject_id"]; $resproject_name = $row["resproject_name"]; $resproject_url = $row["resproject_url"]; $resproject_url_status = $row["resproject_url_status"]; if($resproject_url_status == "Yes") { $resprojects_found .= "
  • $resproject_name
  • "; } else { $resprojects_found .= "
  • $resproject_name
  • "; } } } ?>

    \n"; echo" Overview\n"; echo" \n"; if($resgroup_description) { echo"$resgroup_description
    \n"; } if($resgroup_url) { echo"
    $resgroup_name Web Page

    \n"; } echo" \n"; } ?>
     
    Faculty
    $faculty_found

    \n"; } if($people_found) { echo"Affiliated Faculty
    $people_found

    \n"; } if($others_found) { echo"Related Labs, Centers, and Groups
    $others_found

    \n"; } if($resprojects_found) { echo"Projects
      $resprojects_found


    \n"; } ?>
    $resgroup_photo

    "; } ?>