"; if($pictureURL != '') { $content .= "

"; } $content .=" $projectDesc

"; } else { $groupName = "$deptAbbv Projects"; $content = "The definitive list.

"; $query = "SELECT * from projects ORDER BY projectName"; $groupIDarray = array(); $result = mysql_query($query); $content .= ""; for ($i = 0; $i < mysql_num_rows($result); $i++) { if($i % 2 == 0) { $bgcolor="#D3D3D3"; } else { $bgcolor="#B5B5B5"; } mysql_data_seek($result, $i); $entry = mysql_fetch_array($result); $content .= "\n"; } $content .= "

"; $content .= "$entry[projectName]"; preg_match("|\!([0-9]*)\!|", "$entry[relevantGroup]", $groupIDarray); $query2 = "SELECT * from groups WHERE groupID = '$groupIDarray[1]'"; $result2 = mysql_query($query2); $entry2 = mysql_fetch_array($result2); $content .= ", $entry2[groupName]

"; } ?>

> Projects >
- - , , -