$research_name
\n"; if($count <= $left) { $areas_found1 .= "$research_name
\n"; } else { $areas_found2 .= "$research_name
\n"; } } $area_rows = ''; $sql = "SELECT * FROM research ORDER BY research_name"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $research_id = $row["research_id"]; $research_name = $row["research_name"]; $research_photo = $row["research_photo"]; $photo = "![](\"")
";
if($research_photo)
{
$area_rows .= " $research_name
\n"; if($count <= $left) { $areas_found1 .= "$research_name
\n"; } else { $areas_found2 .= "$research_name
\n"; } } $area_rows = ''; $sql = "SELECT * FROM research ORDER BY research_name"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $research_id = $row["research_id"]; $research_name = $row["research_name"]; $research_photo = $row["research_photo"]; $photo = "
$photo
- ";
}
else
{
$area_rows .= "
- $resgroup_name "; } else { $area_rows .= "
- $resgroup_name "; } //$area_rows .= "
- $resgroup_name "; } $area_rows .= "
- ";
}
$sql2 = "SELECT * FROM resgroup WHERE research_id = " . $research_id . " ORDER BY resgroup_name";
$result2 = mysql_query($sql2) or die (mysql_error());
while ($row2 = mysql_fetch_array($result2))
{
$resgroup_id = $row2["resgroup_id"];
$resgroup_name = $row2["resgroup_name"];
$resgroup_description = $row2["resgroup_description"];
$sql3 = "SELECT * FROM group2 WHERE resgroup_id = " . $resgroup_id;
$result3 = mysql_query($sql3) or die (mysql_error());
$num_rows = mysql_num_rows($result3);
if($resgroup_description || $num_rows > 0)
{ $area_rows .= "
EECS Research Areas
| Main Areas of Research | |
| Main Areas of Research | Area of Research Specialty |