"") {$search=$_GET['hdnText'];} ?> Projects = 2005 ORDER BY start_date DESC LIMIT $from, $max_results"; $result=mysql_query($query); $num=mysql_num_rows($result); $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num from projects where status = 'Active' and substring(start_date,1,4) >= 2005 ORDER BY start_date DESC"),0); $totpages = ceil($total_results / $max_results); if ($total_results == 0 || $num == 0) { $first = 0; $last = 0; $page = 1; } if ($page <= $totpages) { if ($totpages == 1) { $last = $num; $first = 1; } else { $first = $from + 1; if ($num == $max_results) { $last = $from + $max_results; } else { $last = $total_results; } } } } else { $AdvSearch = 1; } if(isset($_GET['Submit'])) { if (isset($_GET['optArea'])) { $SearchString1=$_GET['optArea']; } if (isset($_GET['optCountry'])) { $SearchString2=$_GET['optCountry']; } if (isset($_GET['txtTitle'])) { $SearchString3=$_GET['txtTitle']; } if (isset($_GET['optType'])) { $SearchString4=$_GET['optType']; } if (isset($_GET['txtInvestigator'])) { $SearchString5=$_GET['txtInvestigator']; } if (isset($_GET['optSponsor'])) { $SearchString6=$_GET['optSponsor']; } $max_results = 10; $from = (($page * $max_results) - $max_results); if ($SearchString1=="" && $SearchString2=="" && $SearchString2=="" && $SearchString3=="" && $SearchString4=="" && $SearchString5=="" && $SearchString6=="") {$query="SELECT * FROM projects";} else { $query = "SELECT * FROM projects WHERE substring(start_date,1,4) >= 2005"; if ($SearchString1<>"") {$query= $query . " and areas like '%$SearchString1%'";} if ($SearchString2<>"") {$query= $query . " and country like '%$SearchString2%'";} if ($SearchString3<>"") {$query= $query . " and title like '%$SearchString3%'";} if ($SearchString4<>"") {$query= $query . " and category like '%$SearchString4%'";} if ($SearchString5<>"") {$query= $query . " and lead like '%$SearchString5%'";} if ($SearchString6<>"") {$query= $query . " and sponsor like '$SearchString6%'";} } //$query = $query . " ORDER BY pres_date"; $total_results = mysql_num_rows(mysql_query($query)); $totpages = ceil($total_results / $max_results); $query = $query . " ORDER BY start_date DESC LIMIT $from, $max_results"; $result=mysql_query($query); $num=mysql_num_rows($result); if ($total_results == 0 || $num == 0) { $first = 0; $last = 0; $page = 1; } if ($page <= $totpages) { if ($totpages == 1) { $last = $num; $first = 1; } else { $first = $from + 1; if ($num == $max_results) { $last = $from + $max_results; } else { $last = $total_results; } } } mysql_close(); } ?>

Home | Contact Us | Site Map

Textsize - Large Medium Small 

About Us Research Publications Training Topics News Resources
You are here :  Home > Research > Projects SEARCH IHP find
  
ABOUT US
RESEARCH
  • Research Areas
  • Global research
  • Search our projects
  • PUBLICATIONS
    TRAINING
    TOPICS
    NEWS
    RESOURCES
      
    Global research

    Projects

    IHP staff are involved in many projects both in Sri Lanka and internationally. This section lists those projects that are publicly available.

     
    ">
    SEARCH PROJECTS

    The projects database contains projects. You can search by topic, title, type, authors and date.

     

    Areas:

    Country:

       

    Title (or part of title):

    ">

    Type:

     

    Investigators:

    ">

    Sponsors:

     
    For all Current projects or completed during the year 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005
     
      Current project listing
    - of projects found, listed by date.

     

    ">

     




    Completed:

     

     

     

     

    = 1){ echo "Page: "; for($k = 1; $k <= $totpages; $k++){ if(($page) == $k){ echo "$k "; } else { //echo "$k "; echo "$k"; } } } ?>
    © Copyright IHP. All rights reserved.
    For more information contact