$a = $_GET['a'];
$nombrerio = $id;
include("conectardb.php");
conectarse();
include("nacemuererio2.php");
$resultxxgx = mysql_query("SELECT * FROM rio WHERE a='$a' ORDER BY z DESC") or die("error1");
while($rowxxgx = mysql_fetch_array($resultxxgx))
{
$bn++;
$nombrerio = $rowxxgx['nombre2'];
$z[$bn] = $rowxxgx['z'];
$x[$bn] = $rowxxgx['x'];
$y[$bn] = $rowxxgx['y'];
$largo = $rowxxgx['largo'];
$suv = $z[$bn];
$bbb = $bbb."".$suv.",";
}
mysql_free_result($resultxxgx);
$bbb = $bbb."***";
$bbb = str_replace(",***","",$bbb);
$bn = $bn + 1;
$media = $largo/$bn;
while($h<$bn){$h++;
$toca = ($media + $h*$media); $toca = $toca." km";
$aaa = $aaa.', "'.$toca.'"';
}
$aaa = "***".$aaa;
$aaa = str_replace("***, ","",$aaa);
$res = mysql_query("SELECT * FROM rio WHERE desembocaen LIKE '%$nombrerio%' AND cualidad='ALTO' ORDER BY nombre ASC") or die("error1");
while($ro = mysql_fetch_array($res))
{
$b7++;
$nombrerio7 = $ro['nombre2'];
$bbb7a = $bbb7a."".$nombrerio7.", ";
}
mysql_free_result($res);
if($b7>1){$bbb7a = $bbb7a."***"; $bbb7a = str_replace(", ***",".",$bbb7a); $bbb7 = "Loa afluentes principales del ".$nombrerio." son los siguientes: ".$bbb7a;}
$resultxxg = mysql_query("SELECT * FROM rio WHERE a='$a' ORDER BY z DESC") or die("error1");
while($rowxxg = mysql_fetch_array($resultxxg))
{
$bn++;
$nombrerio = $rowxxg['nombre2']; $desemboca = $rowxxg['desembocaen'];
$z[$bn] = $rowxxg['z'];
$x[$bn] = $rowxxg['x'];
$y[$bn] = $rowxxg['y'];
$idd[$bn] = $rowxxg['id'];
$xxx1 = $x[$bn] - 10*0.009; $xxx2 = $x[$bn] + 10*0.009;
$yyy1 = $y[$bn] - 10*0.009; $yyy2 = $y[$bn] + 10*0.009;
$xxx1y = $x[$bn] - 7*0.009; $xxx2y = $x[$bn] + 7*0.009;
$yyy1y = $y[$bn] - 7*0.009; $yyy2y = $y[$bn] + 7*0.009;
$xxm = $xxm + $rowxxg['x'];
$yym = $yym + $rowxxg['y'];
$imm3 = $imm3." ((x<".$xxx2y." AND x>".$xxx1y.") AND (y<".$yyy2y." AND y>".$yyy1y.")) OR ";
$imm = $imm." ((x<".$xxx2." AND x>".$xxx1.") AND (y<".$yyy2." AND y>".$yyy1.")) OR ";
$imm2 = $imm2." ((x2<".$xxx2." AND x2>".$xxx1.") AND (y2<".$yyy2." AND y2>".$yyy1.")) OR ";
$lukas = $lukas." ((x<".$xxx2y." AND x>".$xxx1y.") AND (y<".$yyy2y." AND y>".$yyy1y.")) OR ";
}
mysql_free_result($resultxxg);
$xxm = $xxm/$bn;
$yym = $yym/$bn;
$imm = $imm."***"; $imm = str_replace("OR ***","",$imm);
$imm2 = $imm2."***"; $imm2 = str_replace("OR ***","",$imm2);
$imm3 = $imm3."***"; $imm3 = str_replace("OR ***","",$imm3);
$lukas = $lukas."***"; $lukas = str_replace("OR ***","",$lukas);
$bajo = $z[$bn];
$alto = $z[1];
$sqqq = "SELECT * FROM todomunicipios WHERE (".$imm.") ORDER BY municipio ASC";
$tablaqqq = mysql_query($sqqq) or die("error2");
while ($rowqqq=mysql_fetch_array($tablaqqq))
{
$utc2 = trim($rowqqq['utc']);
$utc = $utc2[0];
$munnn = $rowqqq['identificador'];
$utcqqq = $utcqqq." estado LIKE '%".$utc2."%' OR ";
$muuu = $muuu." nombre='".$rowqqq['municipio']."' OR ";
}
mysql_free_result($tablaqqq);
$utcqqq = $utcqqq."***";
$utcqqq = str_replace("OR ***","",$utcqqq);
$muuu = $muuu."***";
$muuu = str_replace("OR ***","",$muuu);
$yyy=0;
$sql2j = "SELECT * FROM pueb WHERE (".$imm3.") ORDER BY z DESC";
$tabla2j = mysql_query($sql2j) or die("error2");
while ($row2j=mysql_fetch_array($tabla2j))
{
$yyy++;
$nomaaa = $nomaaa." ".$row2j['pueblo']." (".$row2j['provincia']."), ";
}
mysql_free_result($tabla2j);
$nomaaa = $nomaaa."***";
$nomaaa = str_replace(", ***",".",$nomaaa);
$j=0;
$resultxv = mysql_query("SELECT * FROM animales WHERE (".$utcqqq.") AND reino='Confirmada' ORDER BY grupo,importancia,nombre2 DESC")
or die("error3");
while($rowxv = mysql_fetch_array($resultxv))
{
$j++;
$nm1 = $rowxv['nombre2'];
$imp = $rowxv['importancia'];
if($nm1!=$nm2 AND $j!=1)
{
if($imp2>4){if($imp2>6){$impor = $impor.", ".$nm2."";}else{$impor = $impor.", ".$nm2;}}
}
$nm2 = $nm1;
$imp2 = $imp;
}
mysql_free_result($resultxv);
if($nm1!=$nm2)
{
if($imp2>6){$impor = $impor.", ".$nm2."";}
else
{$impor = $impor.", ".$nm2;}
}
mysql_free_result($resultxv);
$impor = "***".$impor; $impor = str_replace("***,","",$impor);
$resultxz = mysql_query("SELECT * FROM playas WHERE (".$imm2.") ORDER BY nombre ASC") or die("error4");
while($rowxz = mysql_fetch_array($resultxz))
{
$bnvv++;
$playa1 = $rowxz['nombre'];
$playa2 = $rowxz['nombre2'];
$muni1 = $rowxz['municipio']; $prov1 = $rowxz['provincia'];
$longi1 = $rowxz['longitud']; $lngg = $lngg + $longi1;
$anch1 = $rowxz['anchura'];
$condb1 = $rowxz['condicionesbano'];
$cvb2 = $cvb2." ".$playa1.", ";
$arena1 = $rowxz['arena']; $ocup1 = $rowxz['ocupacion'];
$tyty = $tyty." ".$playa1." ".$playa2." ".$muni1." (".$prov1.") Playa con longitud de ".$longi1." y anchura de ".$anch1.".
Es una playa con un ".strtolower($condb1)." y una arena ".strtolower($arena1).". Es una playa con nivel de ocupación ".strtolower($ocup1).".
";
}
mysql_free_result($resultxz);
if($bnvv>0){$plaaaya = $cvb2."***"; $plaaaya = str_replace(", ***",".",$plaaaya);
$plaaaya = "El ".$nombrerio." tiene ".$lngg." m de playas en su entorno; son las siguientes playas: ".$plaaaya."
";}
$rooozx = mysql_query("SELECT * FROM parquenatural WHERE (".$imm.") ORDER BY nombre ASC") or die("error55");
while($rowxz = mysql_fetch_array($rooozx))
{
$bnvv3++;
$parquenatural = $rowxz['nombre'];
if($bnvv3==1){$pqnt = "El ".$nombrerio." está en el maravilloso ambiente del ".$parquenatural."";}
if($bnvv3>1) {$pqnt = $pqnt.", ".$parquenatural."";}
}
mysql_free_result($rooozx);
if($bnvv3>0){$pqnt = $pqnt.".