".ucfirst($fila[1]).""; } mysql_free_result($dats); mysql_close($con); }//fin select_idioma //============================================================================================ //completar el select de pais function select_pais($mod, $ln){ //establecemos una conexion con la base de datos $server='localhost'; $user='luisfer1_read'; $pass='WxIDdyqLw0'; $base='hoteldigital'; /* Intentamos establecer una conexión persistente con el servidor.*/ $con = mysql_connect($server, $user, $pass); mysql_select_db($base); ///fin conexion $sql="SELECT id_pais, pais_$ln FROM paises WHERE idioma <> '' "; $dats=mysql_query($sql, $con); $forma="lista_$mod"; while( $fila = mysql_fetch_row($dats)){ echo ""; } mysql_free_result($dats); mysql_close($con); }//fin select_idioma //============================================================================================ //============================================================================================ //completar el select de provincia function select_provincia($provincias){ //establecemos una conexion con la base de datos $server='localhost'; $user='luisfer1_read'; $pass='WxIDdyqLw0'; $base='hoteldigital'; /* Intentamos establecer una conexión persistente con el servidor.*/ $con = mysql_connect($server, $user, $pass); mysql_select_db($base); ///fin conexion $sql="SELECT DISTINCT provincia from hoteles ORDER BY provincia ASC "; $dats=mysql_query($sql, $con); while( $fila = mysql_fetch_row($dats)){ echo "