$entry[fname] $entry[lname]"; return $contentvar; } function extAuthors($extAuthorsString) { if($extAuthorsString == null) return; $extAuthorsString = trim($extAuthorsString); if($extAuthorsString == null || $extAuthorsString == "") return null; preg_match_all("%((\!|\@)([0-9A-Za-z\ ]*)(\@|\!))%", $extAuthorsString, $answer, PREG_PATTERN_ORDER); for($i = 0; $i < count($answer[3]); $i++) { if(trim($answer[2][$i] == "@")) { $contentvar .= localAuthors($answer[3][$i]); } else { $contentvar .= trim($answer[3][$i]); } if($i == (count($answer[3]) - 1)) $contentvar .= "."; else $contentvar .= ", "; } return $contentvar; } $query = "SELECT * from projects WHERE relevantGroup LIKE '%!$groupID!%' ORDER BY projectName"; $result = mysql_query($query); if(mysql_num_rows($result) > 0) { $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]"; $content .= "

"; } return $content; ?>