Viewing file: glosario.php (5.18 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<? if (!isset ($cadena)) {
$cadena="A";
}else{
$cadena=$cadena;
}?>
<?php require_once('Connections/oa.php'); ?>
<?php
$cadena_rsGlosario = "0";
if (isset($cadena)) {
$cadena_rsGlosario = (get_magic_quotes_gpc()) ? $cadena : addslashes($cadena);
}
mysql_select_db($database_oa, $oa);
$query_rsGlosario = sprintf("select termino, definicion from glosario where termino LIKE '%s%%' order by termino", $cadena_rsGlosario);
$rsGlosario = mysql_query($query_rsGlosario, $oa) or die(mysql_error());
$row_rsGlosario = mysql_fetch_assoc($rsGlosario);
$totalRows_rsGlosario = mysql_num_rows($rsGlosario);
?>
<html>
<head>
<title>Documento sin título</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/enlaces.css" rel="stylesheet" type="text/css">
</head>
<body>
<p class="textoTitulo">Glosario</p>
<p class="textoSubtitulo">Observatorio Ambiental de Bogotá</p>
<table width="400" border="1" cellspacing="0" cellpadding="0">
<tr class="donkey">
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=A" class="donkey">A</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=B" class="donkey">B</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=C" class="donkey">C</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=D" class="donkey">D</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=E" class="donkey">E</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=F" class="donkey">F</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=G" class="donkey">G</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=H" class="donkey">H</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=I" class="donkey">I</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=J" class="donkey">J</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=K" class="donkey">K</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=L" class="donkey">L</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=M" class="donkey">M</a></div></td>
</tr>
<tr class="donkey">
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=N" class="donkey">N</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=O" class="donkey">O</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=P" class="donkey">P</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=Q" class="donkey">Q</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=R" class="donkey">R</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=S" class="donkey">S</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=T" class="donkey">T</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=U" class="donkey">U</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=V" class="donkey">V</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=W" class="donkey">W</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=X" class="donkey">X</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=Y" class="donkey">Y</a></div></td>
<td>
<div align="center"><a href="index.php?n1=2&n2=26&n3=262&cadena=Z" class="donkey">Z</a></div></td>
</tr>
</table>
<?php if ($totalRows_rsGlosario > 0) { // Show if recordset not empty ?>
<br>
<?php do { ?>
<table width="540" border="0" cellpadding="0" cellspacing="0">
<tr align="left" valign="top">
<td width="180" class="textoSubtitulo"> <div align="left"><?php echo $row_rsGlosario['termino']; ?></div></td>
<td width="380" class="textoNormal"><?php echo $row_rsGlosario['definicion']; ?></td>
</tr>
<tr align="left" valign="top">
<td class="textoSubtitulo"> </td>
<td class="textoNormal"><img src="imagenes/inicio/pica.gif" width="25" height="10"></td>
</tr>
</table>
<?php } while ($row_rsGlosario = mysql_fetch_assoc($rsGlosario)); ?>
<br>
<?php } // Show if recordset not empty ?>
<br>
<?php if ($totalRows_rsGlosario == 0) { // Show if recordset empty ?>
<table width="400" border="1" cellspacing="0" cellpadding="0">
<tr>
<td class="textoSubtitulo"><span class="textoNormal">Por el momento no hay
registros en el Glosario que empiecen por la letra</span> <? echo $cadena?></td>
</tr>
</table>
<?php } // Show if recordset empty ?>
<p> </p>
</body>
</html>
<?php
mysql_free_result($rsGlosario);
?>
|