\n";
$query = "select * from `db_seminar` a, `db_seminar_asoc_people` b, `people` c where a.seminar_id=".$_GET['seminar_id']." and a.seminar_id=b.seminar_id and b.people_id=c.people_id";
$color_flag=0;
$result = mysql_query($query,$db_link)
or die("Query failed : Failed to select the seminar detail from database");
while ($line=mysql_fetch_array($result, MYSQL_ASSOC)){
echo "| Title | ";
if ($line['title']!='')
echo "".$line['title']."";
else
echo "To be announced";
echo " |
";
echo "| Speaker | ".$line['name'];
if ($line['url']!='')
echo " ![Homepage of the speaker](".$server_path."/pics/icon/url.gif) ";
echo " |
";
echo "| Date | ".$line['b_day']."-".$line['b_month']."-".$line['b_year']." ".$line['time']." |
";
echo "| Venue | ".$line['venue']." |
";
// Presentation materials
if ($line['seminar_type']=='Students' || $line['file']!=''){
echo "| Presentation materials | ";
if ($line['private']=='N'){ //Public
if ($line['file']!='')
echo "Download the presentation materials of this talk : ![Download the presentation materials.](".$server_path."/pics/icon/download.gif) ";
else
echo "The presentation materials are not available yet.";
}else
echo "![](".$server_path."/pics/button/important.gif) The presentation materials will be available after this research work is published.";
echo " |
";
}
echo "| In Proceeding / Journal | ";
if ($line['published']!='')
echo $line['published'];
else
echo "N/A";
echo " |
";
echo "| Abstract | ";
if ($line['private']=='N'){ //Public
if ($line['abstract']!='')
echo nl2br(html_entity_decode($line['abstract']));
else
echo "To be announced";
}else{ // Private
echo " The abstract will be available after this research work is published.";
}
echo " |
";
//Comments
echo "| Discussions | ";
if ($line['discussion']!='')
echo "Please click here to leave your comments to this talk.";
else
echo "N/A";
echo " |
";
}
mysql_free_result($result);
echo "| Back to DB Seminar page |
";
echo "
\n";
}else{
echo "Please visit the ![](".$server_path."/pics/page_banner/db_seminars.jpg)