<?
include ("coneccion.inc");
// Listado de Tipo de Contactos
if (!empty($_GET['cod_hotel']))
{
// Listamos los tipos de contactos
// Armo una coneccion al servidor mysql
$coneccion = mysql_connect($host_db, $usuario_db, $pass_db);
mysql_select_db($base_db, $coneccion);
// Armo la consulta
$sql = "SELECT * FROM tarifas, habitacion, regimen
WHERE cod_hotel = $cod_hotel";
$sql.=" AND cod_habitacion = id_habitacion";
$sql.=" AND cod_regimen = id_regimen";
$sql.=" ORDER BY single";
$result = mysql_query($sql, $coneccion);
$myrow = mysql_fetch_array($result);
$result = mysql_query($sql, $coneccion);
$sql1 = "SELECT nombre, observaciones FROM hoteles WHERE id_hotel = $cod_hotel";
$result1 = mysql_query($sql1, $coneccion);
$myrow1 = mysql_fetch_array($result1);
$result1 = mysql_query($sql, $coneccion);
if (mysql_error())
{
echo "ERROR al agregar la ciudad - ". mysql_errno().":". mysql_error()."<br>";
}
// Calculo la cantidad de resultados
$cant_resultados = mysql_num_rows($result);
if ($cant_resultados >= 1)
{
// Muestro los resultados
?>
<div align="left">
<table width="77%" border="0">
<tr>
<td width="80%"><span class="subtitulo">Tarifas del Hotel:</span> <span class="Estilo2">"<? echo $myrow1[nombre];?>" </span></td>
<td width="20%"><div align="center"><A HREF="javascript
:history.back()"><strong>Volver Atrás </strong></A></div></td>
</tr>
</table>
</div>
<p>
<table width="79%" height="87" border="1" bordercolor="#006600">
<tr>
<td width="81" height="23" bgcolor="#009933"><div align="center"><strong>Habitación</strong></div></td>
<td width="46" bgcolor="#009933"><div align="center"><strong>Single</strong></div></td>
<td width="45" bgcolor="#009930"><div align="center"><strong>Doble</strong></div></td>
<td width="45" bgcolor="#009933"><div align="center"><strong>Triple</strong></div></td>
<td width="78" bgcolor="#009933"><div align="center"><strong>Cuadruple</strong></div></td>
<td width="103" bgcolor="#009933"><div align="center"><strong>Family Plan </strong></div></td>
<td width="83" bgcolor="#009933"><div align="center"><strong>Validez</strong></div></td>
<td width="82" bgcolor="#009933"><div align="center"><strong>Regimen</strong></div></td>
<td width="32" bgcolor="#009933"><div align="center"><strong>OBS</strong></div></td>
</tr>
<?
while($myrow = mysql_fetch_array($result))
{
?>
<tr>
<td height="22" align="left"><? echo $myrow[desc_habitacion]; ?></td>
<td width="46" align="center" valign="middle"><? echo $myrow[single]; ?></td>
<td width="45" align="center" valign="middle"><? echo $myrow[doble]; ?></td>
<td width="45" align="center" valign="middle"><? echo $myrow[triple]; ?></td>
<td width="78" align="center" valign="middle"><? echo $myrow[cuadruple]; ?></td>
<td width="103" align="center" valign="middle"><? echo $myrow[family_plan]; ?></td>
<td width="83" align="center" valign="middle"><? echo $myrow[validez]; ?></td>
<td width="82" align="center" valign="middle"><? echo $myrow[desc_regimen]; ?></td>
<td width="32" align="center" valign="middle"><? echo $myrow[ob]; ?></td>
</tr>
<tr>
<td height="32" colspan="9" align="left"><? echo $myrow1[observaciones]; ?></td>
</tr>
<?
}
?>
<?
}
else
{
// end while
?>
<table width="100%" border="0">
<tr>
<td width="100%" scope="col"><div align="center" class="subtitulo">No hemos encontrado registros</div></td>
</tr>
</table>
<?
}
}
?>
</table>