"; while ( $row = mysql_fetch_array($result)){ extract($row); echo ""; if($logo) echo ""; else echo ""; echo(""); echo "
$name"; echo "Project Type: $ptname"; echo "Research Field: $pjarea"; if (strlen($sponsors) > 2 ) echo "Sponsors: $sponsors"; if (strlen($timespan) > 2 ) echo "Time span: $timespan"; if (strlen($link) > 2) echo "Webpage"; if($poster){ echo ""; echo ""; echo "
Poster
"; } if($prospect){ echo ""; echo ""; echo "
Prospect
"; } echo "
Description:
$description"; } echo ""; } //********************************* Projects ***************************************** $query = "select pj.ID, a.projectb, pjb.name, pjb.logo from Projects pj, (select pa.ID, propro.projecta, propro.projectb from Projects pa, propro where pa.ID = propro.projecta union select pa.ID, propro.projectb, propro.projecta from Projects pa, propro where pa.ID = propro.projectb ) a, Projects pjb where a.ID = pj.ID and pj.ID = a.projecta and pjb.ID = a.projectb and pj.ID= ".$_GET['ID']." order by pj.ID"; $result = mysql_query($query) or die ("Couldn’t execute query.
$query
".mysql_error()); $num_rows = mysql_num_rows($result); if ($num_rows) echo("

Related Projects

"); echo("

"); while ( $row = mysql_fetch_array($result)){ extract($row); echo ""; if($logo){ echo ""; } else{ echo ""; } echo ""; // echo("".$name."
"); } echo("
"; echo ""; echo ""; echo "".$name."

"); //********************************* People ***************************************** // this part was written by pedrotrindade@isr.uc.pt - 15/Nov/2011 $query = "select * from mrl.peopro left join mrl.People on mrl.peopro.people = mrl.People.ID where mrl.peopro.project=".$_GET['ID']." and peopro.active = 1 and peopro.public = 1 order by mrl.People.ID"; $result = mysql_query($query) or die ("Couldn't execute query.
$query
".mysql_error()); $num_rows = mysql_num_rows($result); if ($num_rows) echo("

Related People

"); echo("

"); while ( $row = mysql_fetch_array($result)){ extract($row); echo ""; if($photo){ echo ""; } else{ echo ""; } echo ""; } echo("
"; echo ""; echo ""; echo "".$name."

"); // *** END of PEOPLE mysql_close($dblink); include 'config.php'; include 'opendb.php'; ?>