<?
if(isset($_REQUEST['Enviar'])){
$mes= $_REQUEST['cb_mes'];
$stmt1=mssql_init("estadistica_ger_requerimientos",$conexion);
mssql_bind($stmt1,"@mes",$mes,SQLVARCHAR,FALSE);
$query_uno=mssql_execute($stmt1);
$query=mssql_query("select * from mc_grafico_ger_requerimiento",$conexion);
$num = mssql_num_rows($query);
if($num < 1 ){
echo "<h1><center><font color='red'>¡Lo Sentimos!</font></center></h1>";
echo "<center><font color='blue'>No Hay Campañas Registradas en el Mes Seleccionado</font></center>";
echo "<p><center><font color='blue'>Elija otro Mes</font></center></p>";
echo "<br /><br /><br />";
}else{
echo"<table class='tabla_combinada' border='1' width='70%' align='center'>";
echo "<tr>";
echo "<th align='center' height='33px' class='tabla1'>Direccion</font></th>";
echo "<th align='center' class='tabla1'>Cantidad</th>";
echo "</tr>";
while($row=mssql_fetch_array($query)){
?>
<tr>
<td align='center' bgcolor='#F5FFFA'><strong><? echo $row[nom_direccion]?></strong></td>
<td align='center' bgcolor='#F5FFFA'><? echo $row[cantidad]?></td>
<?
?>
<link rel="stylesheet" type="text/css" href="../../ext-3.4.0/resources/css/ext-all.css" />
<link rel="stylesheet" type="text/css" href="../../ext-3.4.0/resources/css/xtheme-gray.css" /> <!-- slate/gray -->
<script type="text/javascript" src="../../ext-3.4.0/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="../../ext-3.4.0/ext-all.js"></script>
<style type="text/css">
body {
color: black;
background-color: #EAF4FF
}
</style>
<script type="text/javascript" src="grafico_ger_requerimiento.js"></script>
<script type="text/javascript" src="reload-chart.js"></script>
<div id="container1"></div>
<?
}
}
} else {
echo "<h1><center><font color='white'>!Seleccione Criterios de Búsqueda!</font></center></h1>";
echo "<br /><br /><br />";
}
echo "</table>";
?>