$result='';
if($widget_title!='')
$result='
'.stripslashes($widget_title).'
'; $result.='- ';
$gallery_from_array=array("g"=>"Photos", "n"=>"News", "e"=>"Events", "m"=>"Media", "p"=>"Placement", "r"=>"Research");
$about_query="( SELECT 'p', A.id, A.n_date, A.title FROM web_research_gallery AS A INNER JOIN web_photos AS B ON A.id=B.ref_id where A.del = 1 AND A.web_view=1 AND B.del =1 AND B.photos_from = 'Research' ) ORDER BY n_date DESC";
//echo $about_query;
$about_result=mysqli_query($GLOBALS["__mySQLiHMS"],$about_query);
while(($rows_about= mysqli_fetch_array($about_result))!=false)
{
$gfrom=$rows_about[0];
$a_id=$rows_about[1];
$n_date=$rows_about[2];
$n_title=$rows_about[3];
$n_date=date('Y-m-d',strtotime($n_date));
$n_title=stripslashes($n_title);
$h_link_1=urlparseString($gfrom.$n_date);
$h_link_2=urlparseString($n_title);
$gfrom=$gallery_from_array[$gfrom];
$query_1="SELECT * FROM web_photos WHERE del =1 AND ref_id='$a_id' AND photos_from = '$gfrom' ORDER BY id ASC" ;
$result_1=mysqli_query($GLOBALS["__mySQLiHMS"],$query_1);
$result_count = mysqli_num_rows($result_1);
$rows_1 = mysqli_fetch_array($result_1);
$gallery_photo = $rows_1["c_attachment"];
$d_n_title = parseString($n_title ,30,1);
if(strlen($n_title) >35)
$d_n_title.='...';
$gallery_link=WEBSITE_URL.'/download/photos/'.$gallery_photo;
/*if(file_exists($gallery_link) && $gallery_photo)
$gallery_link=WEBSITE_URL.'/download/photos/'.$gallery_photo;
else
$gallery_link= WEBSITE_URL.'/images/webimage.jpg';*/
$result.='
- '.$d_n_title.'';
}
$result.="
Student Placement () |