Meetings
require("../../openmydatabase.php");
$link = openmysqlserver();
$db = mysql_select_db($_database,$link) or die ("no link to the Center ");
$day=date("z")+(date("y")-6)*365;
$sql= "SELECT * FROM lecture WHERE pub='1'&& order_start >= '$day' && lec_cour='m' ORDER BY order_start ASC ";
//echo $sql;
$res=mysql_query($sql,$link);
if(mysql_num_rows($res) >0)
{
seeMeetings($res);
}
else
{
echo"
to be announced soon.
";
}
$sql1= "SELECT * FROM lecture WHERE pub='1'&& order_start < '$day' && lec_cour='m' ORDER BY order_start DESC ";
//echo $sql1;
$res1=mysql_query($sql1,$link);
if(mysql_num_rows($res1) >0)
{ ?>
Achieved meetinngs
seeMeetings($res1); ?>
}
?>