$con= mysqli_connect("localhost", "abpc_db", "*wmpr77Mc6enzIag","abpc_db") ;
echo"
Notice No. | Date | Meeting Date | Subject | Full Notice";
$i=1;
$result1 = mysqli_query($con,"SELECT * FROM notice1 order by date DESC");
while($r=mysqli_fetch_array($result1)){
$type=$r['type'];$no=$r['num'];$y=$r['year'];$sub=$r['sub'];$date=$r['date'];$mdt=$r['meetingdate'];
$date=$r['date'];$minutesfile=$r['minutesfile'];$subfile=$r['subfile'];
if($i%2==1)echo" |
---|
";
else{echo" ";}
$date=date('d-m-Y',strtotime($date)) ;
echo"$type/$no/$y | $date | $mdt | $sub ";
echo" | $r[minutes] ";
if($minutesfile!='')echo"View File";
$i=$i+1;
}
| |