<?php
include_once('databasecon.php');//to make database connecti
$cap="<table align=center border=1px><th>PERSONAL DETAILS</th>";//CAPTION OF THIS REPORT
$title="<tr><td><b>NAME</b></td><td><b>E-MAIL</b></td><td><b>CITY</b></td></tr>";//TABLE HEADER
$tmp_per_res=mysql_query("select * from personalinfo");
while($row=mysql_fetch_array($tmp_per_res,MYSQL_BOTH))
{
$body.="<tr><td>".$row['vName']."</td><td>"
.$row['vEmail']."</td><td>"
.$row['vCity']
."</td></tr>";
}
echo $cap.$title.$body."</table>";
?>
|