|
$i=0;
while ($i < $num) {
$project_id=mysql_result($result,$i,"project_id");
$budget_id=mysql_result($result,$i,"budget_id");
$title=mysql_result($result,$i,"title");
$start_date=mysql_result($result,$i,"start_date");
$end_date=mysql_result($result,$i,"end_date");
$areas=mysql_result($result,$i,"areas");
$country=mysql_result($result,$i,"country");
$region=mysql_result($result,$i,"region");
$category=mysql_result($result,$i,"category");
$short_desc=mysql_result($result,$i,"short_desc");
$abstract=mysql_result($result,$i,"abstract");
$sponsor=mysql_result($result,$i,"sponsor");
$client=mysql_result($result,$i,"client");
$partners=mysql_result($result,$i,"partners");
$lead=mysql_result($result,$i,"lead");
$consultant=mysql_result($result,$i,"consultant");
$team=mysql_result($result,$i,"team");
$status=mysql_result($result,$i,"status");
$image1=mysql_result($result,$i,"image1");
$intlinktext1=mysql_result($result,$i,"intlinktext1");
$intlinktext2=mysql_result($result,$i,"intlinktext2");
$intlinktext3=mysql_result($result,$i,"intlinktext3");
$intlinktext4=mysql_result($result,$i,"intlinktext4");
$intlinktext5=mysql_result($result,$i,"intlinktext5");
$intlink1=mysql_result($result,$i,"intlink1");
$intlink2=mysql_result($result,$i,"intlink2");
$intlink3=mysql_result($result,$i,"intlink3");
$intlink4=mysql_result($result,$i,"intlink4");
$intlink5=mysql_result($result,$i,"intlink5");
$extlink1=mysql_result($result,$i,"extlink1");
$extlinktext1=mysql_result($result,$i,"extlinktext1");
$extlink2=mysql_result($result,$i,"extlink2");
$extlinktext2=mysql_result($result,$i,"extlinktext2");
$extlink3=mysql_result($result,$i,"extlink3");
$extlinktext3=mysql_result($result,$i,"extlinktext3");
$extlink4=mysql_result($result,$i,"extlink4");
$extlinktext4=mysql_result($result,$i,"extlinktext4");
$extlink4=mysql_result($result,$i,"extlink4");
$extlinktext4=mysql_result($result,$i,"extlinktext4");
$extlink5=mysql_result($result,$i,"extlink5");
$extlinktext5=mysql_result($result,$i,"extlinktext5");
$extlink6=mysql_result($result,$i,"extlink6");
$extlinktext6=mysql_result($result,$i,"extlinktext6");
$extlink7=mysql_result($result,$i,"extlink7");
$extlinktext7=mysql_result($result,$i,"extlinktext7");
$extlink8=mysql_result($result,$i,"extlink8");
$extlinktext8=mysql_result($result,$i,"extlinktext8");
$extlink9=mysql_result($result,$i,"extlink9");
$extlinktext9=mysql_result($result,$i,"extlinktext9");
$extlink10=mysql_result($result,$i,"extlink10");
$extlinktext10=mysql_result($result,$i,"extlinktext10");
$extlink11=mysql_result($result,$i,"extlink11");
$extlinktext11=mysql_result($result,$i,"extlinktext11");
$extlink12=mysql_result($result,$i,"extlink12");
$extlinktext12=mysql_result($result,$i,"extlinktext12");
?>
|
|
|
|
if ($image1<> "") { ?>
} else {echo ""; }?> |
if ($intlink1 <> "") { ?>
" target="_self"> Read in full
} else {echo "" ;} ?> |
IHP publications & reports |
$i=0;
while ($i < $numIHPPub) {
$id=mysql_result($resultIHPPub,$i,"id");
$title=mysql_result($resultIHPPub,$i,"title");
?>
|
$i++; }?>
if ($numIHPPub==0) { ?>
None available |
} ?>
|
External publications |
if ($numExtPub <> "") { ?> - if ($title <> "") { ?> echo $title; ?> ; } ?>
; } ?> |
None available |
|
Presentations |
$i=0;
while ($i < $numPres) {
$id=mysql_result($resultPres,$i,"id");
$ppt_no=mysql_result($resultPres,$i,"ppt_no");
$title=mysql_result($resultPres,$i,"title");
$pres_date=mysql_result($resultPres,$i,"pres_date");
$category=mysql_result($resultPres,$i,"category");
$topic=mysql_result($resultPres,$i,"topic");
$yr=substr($pres_date,2,2);
if ($yr=="06")
{
$yr="";
}
?>
|
$i++; }?>
if ($numPres==0) { ?>
None available |
} ?>
|
Project
at a glance |
|
Project
team |
Start Date: |
echo ucfirst(date("M Y", strtotime("$start_date"))); ?> |
End
Date: |
if ($end_date == "0000-00-00")
{echo "Ongoing";} else {echo ucfirst(date("M Y", strtotime("$end_date")));}; ?> |
Themes: |
echo $areas ?> |
Sponsor(s): |
echo $sponsor ?> |
Client: |
echo $client ?> |
|
|
IHP Staff: |
echo $team ?> |
Consultant(s): |
echo $consultant ?> |
|
|
Location |
|
Further
information |
Region: |
echo $region ?> |
Country(s): |
echo $country ?> |
Partner(s): |
echo $partners ?> |
|
|
|
|
$i++; }?>
|
|
if ($image1 <> "blank.jpg") { ?>
![project](../images/project/<? echo $image1 ?>) |
} else {echo ""; }?>
|
Related
news |
|
$i=0;
while ($i < $numNews) {
$id=mysql_result($resultNews,$i,"id");
$news_id=mysql_result($resultNews,$i,"news_id");
$title=mysql_result($resultNews,$i,"title");
$text1=mysql_result($resultNews,$i,"text1");
$news_date=mysql_result($resultNews,$i,"news_date");
$yr=substr($news_date,2,2);
if ($yr=="06")
{
$yr="";
}
?>
if ($numNews <> "0") { ?>
echo ucfirst(date("j M Y", strtotime("$news_date"))); ?>: echo $title;?>
} ?>
|
$i++; }?>
|
|