$con= mysqli_connect("localhost", "abpc_db", "*wmpr77Mc6enzIag","abpc_db") ;
echo"
Year | Date | Order No. | Type
| Subject | Link";
if($_POST['type']==''){
$i=1;
$result1 = mysqli_query($con,"SELECT * FROM go order by date DESC");
while($r=mysqli_fetch_array($result1)){
$y=$r['year'];$sub=$r['sub'];$date=$r['date'];$link=$r['link'];$order=$r['orderno'];$type=$r['type'];
if($i%2==1)echo" |
---|
";
else{echo" ";}
$date=date('d-m-Y',strtotime($date)) ;
echo"$y | $date | $order | $type | $sub
| View File ";
$i=$i+1;
}
}
else{
$type=$_POST['type'];
$i=1;
if($type=='yr')$result1 = mysqli_query($con,"SELECT * FROM go where year='$yr' order by date DESC");
$result1 = mysqli_query($con,"SELECT * FROM go where type='$type' order by date DESC");
while($r=mysqli_fetch_array($result1)){
$y=$r['year'];$sub=$r['sub'];$date=$r['date'];$link=$r['link'];$order=$r['orderno'];$type=$r['type'];
if($i%2==1)echo" | ";
else{echo" ";}
$date=date('d-m-Y',strtotime($date)) ;
echo"$y | $date | $order | $type | $sub
| View File ";
$i=$i+1;
}
}
| |