<link href="../css/form.css" type="text/css" rel="stylesheet" media="screen"  />

<link href="../css/printline.css" type="text/css" rel="stylesheet" media="print,screen"  />


<html>
<body >

<?
session_start();
include("../opendb.php");
include("../test.php");
?>
<head>
<TITLE>EXECUTIVE WISE REPORT</TITLE>
<style>
tr{font-family:arial;font-size:13;background-color:white}
TH{COLOR:WHITE;BACKGROUND-COLOR:STEELBLUE}
</style>

<link rel="stylesheet" href="style.css" type="text/css" />
</head>
<CENTER>

<?

print "<FONT FACE='ARIAL BLACK' color='black'>
PROSPECT LIST 
</FONT>";

 print "<table cellspacing=1 cellpadding=2 bgcolor='steelblue' width=100% border=1 class='grid'>";
 print "<tr><td>No</td> <td>Prospect </td><td>Addr1 </td><td>Addr2</td><td>City</td><td>Mobile</td><td>User</td><td>CreatedOn</td>";


 $re2=mysqli_query($db,"select * from prospmaster where exec='$user' order by ondate,ontime ");
 $i=1;
 while($row1=mysqli_fetch_array($re2))
 {
  

  print "\n<tr><td>".$i++."</td>";
  print "<td>$row1[pname]</td>";

  print "<td>".$row1[addr1]."</td>";
  print "<td>".$row1[addr2]."</td>";
  print "<td>".$row1[city]."</td>";
  print "<td>".$row1[mob]."</td>";
  print "<td>".$row1[exec]."</td>";
 print "<td>".datetohtml($row1[ondate])."</td>";

 }
 print "\n</table><br>";



