<?php
include 'dbcon.php';
$result = mysqli_query($conn, "SELECT * from actvty_trans_frzng_embryo order by date(term_date) DESC");
$data="<table width=100% border='1' class='imagetable'>";
$data.="<tr><td>Patient MRN</td><td>Straw No.</td><td>Nos Embryo</td><td>Freezing Date</td><td>Due Date</td></tr>";
while($row=mysqli_fetch_array($result)) 
{
$data.="<tr><td>".$row['pat_id']."</td><td>".$row['strow_no']."</td><td>".$row['nosoocyt']."</td><td>".$row['due_date_act']."</td><td>".$row['term_date']."</td></tr>";
}
$data.="</table>";
echo $data;

//include_once('class.phpmailer.php');
//$mail = new PHPMailer();
//$mail->IsSMTP();
//$mail->Host = "localhost";
//$mail->SMTPDebug = 1;
//$mail->SMTPAuth = true;
//$mail->Username = "noreply@novaivf.in";
//$mail->Password = "N3%9Gw[d*n)v";
//$mail->From       = "noreply@novaivf.in";
//$mail->FromName   = "RFID EWS - NOVA IVF";
//$mail->Subject = "Freezing data - Gorakhpur";
//$mail->addAddress('chetan.solanki@novaivffertility.com', 'Freezing data - Gorakhpur');
//$mail->AltBody = "To view the message, please use an HTML compatible email viewer!";
//$mail->MsgHTML($data);
//if(!$mail->Send()){
//  echo "Mailer Error: " . $mail->ErrorInfo;
//} else {
//}
?>