<?php
		
		include("database.php");

?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Survey Application</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<!--<link rel="stylesheet" type="text/css" href="css/page.css">
<link href="css/admincss.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="css/ddsmoothmenu.css" />-->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script type="text/javascript" src="js/ddsmoothmenu.js">
</script>

<script type="text/javascript">

ddsmoothmenu.init({
	mainmenuid: "smoothmenu1", //menu DIV id
	orientation: 'h', //Horizontal or vertical menu: Set to "h" or "v"
	classname: 'ddsmoothmenu', //class added to menu's outer DIV
	//customtheme: ["#1c5a80", "#18374a"],
	contentsource: "markup" //"markup" or ["container_id", "path_to_menu_file"]
})



</script>
<style type='text/css' media='print'>
#prnt {display : none}
#header{display:none;}
#footer{display:none;}
#back {display : none}

</style>
</head>

<body class="body">

<div id="wrap" >
  
  
  <div id="top">
<!--    <?php include("header.php"); ?>
-->    <!--<div id="ban"><table width="1004" align="left"  >
  <tr>
    <td width="234"  align="left"  valign="top" ><img src="images/logoss.jpg" border="0" /></td>
    <td  valign="top" style="padding-top:5px;" width="758"  align="right" ><table align="left" width="707">
  <tr>
    <td width="386" align="left"><div ><a href="#" id="bantext1">REQUEST A DEMO</a></div></td>
    <td width="167" align="left"><div ><a href="#" id="bantext2">DOWNLOADS</a></div></td>
    <td width="138" align="left"><div ><a href="#" id="bantext2">DOWNLOADS</a></div></td>
  </tr>
  <tr>
    <td colspan="3" align="center" class="banquot">Be Smart and Survey Smartly </td>
  </tr>
</table></td>
    
    
  </tr>
</table>
    </div>-->
    
    </div>
    </div>
   <div id="menuholder"><?php /*?><?php include("adminmenu.php"); ?><?php */?></div>
   <div id="contholder">
   
    
    <!--<div id="nav">
     <ul>
     <li><a href="adminhome.php" id="home_on">HOME</a></li>
        <li><a href="adminproducts.php" id="products_on">PRODUCTS</a></li>
		<li><a href="adminfeatures.php" id="features_on">FEATURES</a></li>
        <li><a href="adminadvantages.php" id="advantages_on">ADVANTAGES</a></li>
        <li><a href="adminhowitworks.php" id="howitworks_on">HOW IT WORKS</a></li>
        <li><a href="adminhelp.php" id="help_on">HELP</a></li>
        <li><a href="admincontactus.php" id="contactus_on">CONTACT US</a></li>
    
    </ul>
    
    </div>-->
    
   
    	<div id="contdata">
   <hr width="80%"></hr>
<center><font face="Verdana" size="2"><b>Total Number of Trees In a Ward</b></font></center>
<hr width="80%"></hr>
<br>
<table border='0' width='80%'  align='center'  style='font-family:Verdana; font-size:10pt; border-collapse: collapse;'>
    <tr>
        <td align="right">
            <input type="button" value="Print" id="prnt" name="print" onClick="window.print()" align="center" >
            <a href="total_tree_ward.php" id="back"style="text-decoration:none; "><input type="button" value="Cancel" name="cancel" >  </a>
        </td>
    </tr>
</table>
<br>
<?php
	if($_GET['q']!="")
{	

	$q=$_GET["q"];
	$sql1= mysql_fetch_array(mysql_query("select * from master_ward where wid='$q'"));
	$sql="select t1.ward_office,t2.tree_name,t2.scientific_name from input_form as t1 left join info as t2 on t1.id = t2.aid where t1.ward_office='$q'  ";
	$ward = $sql1['wvalue'];
	//echo "select t1.ward_office,t2.tree_name from input_form as t1 left join info as t2 on t1.id = t2.aid where t1.ward_office='".$sql1['wvalue']."' ";
	$rest = mysql_query($sql);
	$num = mysql_num_rows($rest); 
echo "<center><b><font face='Verdana' size='2'>Ward Name : </font></b> ".$ward ."<br/><br/></center>";	
echo "<center><b><font face='Verdana' size='2'>Records Found : </font></b> ".$num ."<br/><br/></center>";
echo "<table border='1' align='center'  style='font-family:Verdana; font-size:10pt; border-collapse: collapse; width:30%'>

<tr>

<th align='left'>Tree Name</th>
<th align='left'>Scientific Tree Name</th>


</tr>";


	 while ($row =@mysql_fetch_object($rest)) 
{
	
	$query_tree = mysql_query("select * from tree_name where tid= '".$row->tree_name."'");
	$result_tree = mysql_fetch_array($query_tree);
	
	echo "<tr>";
	
	echo "<td align='left'>" . $result_tree['tree_name'] . "</td>";
	echo "<td align='left'>" . $result_tree['scientific_name'] . "</td>";


}
?>
</table>
<?php
echo "</tr>";
 
}
?>

</table>
		
<?php /*?>	<?php include("footer.php"); ?>	
<?php */?>    
   </div>
    

    	
   </div> 

<!--<div id="footer">Copyright © 2012.Smart Survey All Rights Reserved.Website Designed & Developed by Kalpak Solutions</div>-->





</body>
</html>