Untitled

<?php
$host="localhost";//Hostname""
$username="";//Mysqlusername
$password="";// Mysql password
$db_name="test"; // Database name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$data=mysql_query(" SELECT Tag,Serial, manufacturer, model, Warranty_date FROM     asset_view WHERE DATEDIFF(Warranty_date, CURDATE())<90");

$count = mysql_num_rows( $data );
if($count==0)
{
echo 'no records';
exit;
} else {

$body = '<html><b>
<table border="0" width="70%"><tr><td>Tag</td><td>Serial</td> <td>Model</td>
<td>Manufacturer</td> <td>Warranty date</td></b>
</tr>';


while ($row = mysql_fetch_array($data)){
 $body .= '<tr>

<td>'.$row['Tag'].'  </td>
<td>'.$row['Serial'].'</td>
<td>'.$row['model'].'</td>
<td>'.$row['manufacturer'].'</td>
<td>'.$row['Warranty_date'].'</td>
</tr>';

  }
  $body .=  '</table> </html>';


  echo $body;


  // To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "rn";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "rn";

// Additional headers
$headers .= 'To:Admin <test89714@gmail.com>' . "rn";
$headers .= 'From:CIMS <test89714@gmail.com>' . "rn";


$email = "test89714@gmail.com";
$subject = "Asset Warranty expiry reminder";


mail($email,$subject,$body,$headers);
echo 'sent';
}
?>