// MySQL Settings
$DbServer = "localhost";
$DbUser = "ccc";
$DbPass = "pdbdjc";
$DbName = "cccsuelos";
$Conn = mysql_connect("localhost", $DbUser, $DbPass);
mysql_select_db($DbName);
// make connection to database
$dblink=mysql_connect($DbServer, $DbUser, $DbPass) OR DIE("Unable to connect to database");
@mysql_select_db("$DbName") or die( "Unable to select database");
// color settings
$tblhead = "#FF9933";
$oncolor = "#FFCC66";
$offcolor = "#FFFFFF";
?>
$query = "Select Uso, count(Uso) as numuso,SUM(Porcentaje) as sumapor From listado Where Sector = '".$_GET['sector']."' group By Uso order By numuso DESC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
?>
|
|
$query5 = "Select count(*) as totalmanzana From listado where Sector = '".$_GET['sector']."' ";
$result5 = mysql_query($query5);
$row5 = mysql_fetch_array($result5);
$cod2 = $row5['totalmanzana'];
// operacion de porcentaje
$val1= $row['numuso'];
$val2= $val1 * 100;
$porcentaje= $val2 / $cod2;
echo round($porcentaje, 2)." %" ;
//echo $porcentaje. ;
?>
|
echo $row['numuso']; ?> |
|
}
?>
|
: echo $_GET['sector']; ?> |
 |
:
$query5 = "Select count(*) as totalmanzana From listado where Sector = '".$_GET['sector']."' ";
$result5 = mysql_query($query5);
$row1 = mysql_fetch_array($result5);
$cod2 = $row1['totalmanzana'];
echo $cod2;
?>
|
|
$query7 = "Select * From sector where codigo = '".$_GET['sector']."' ";
$result7 = mysql_query($query7);
$row7 = mysql_fetch_array($result7);
$cod7 = $row7['direccionimg'];
//echo $cod7;
?>
|