Rutas por Cantabria y Picos de Europa
Home
Pgina Principal
Contact me
Contacto
Versión en español English version Version franaise Versione italiana Deutsch version 
List of the best restaurants of Cantabria y Picos de Europa
LIST OF RESTAURANTS
Print page
Imprimir
Send to a friend
Enviar a un amigo
Below is a list of recommended restaurants, and it contains probably the best restaurants of Cantabria. Soon, we will be adding more restaurants of all price range at all the zones of Cantabria.

Map with the list of recommended restaurants

Find by:   Zone:    Price:  
conexin:" . mysql_errno($comments_db_link) . ": " . mysql_error($comments_db_link). "\n"; $db_selected = mysql_select_db("cantabria", $comments_db_link); if (!$db_selected) { echo ('Can\'t use foo : ' .mysql_error($comments_db_link)); } main1(); function main1() { global $comments_db_link; $comarca= $_POST["comarcaFiltro"]; $precio= $_POST["precioFiltro"]; $sSql="SELECT nombre,direccion,comarca,poblacion,precioMin,precioMax,id from restaurantes where 1=1"; if ($comarca!=""){ $sSql=$sSql." and comarca=".$comarca; echo ''; } if ($precio!=""){ $token = strtok($precio,"|"); $precioMin=$token; $token = strtok("|"); $precioMax=$token; $sSql=$sSql." and precioMin>=".$precioMin." and precioMax<=".$precioMax; echo ''; } $sSql=$sSql." order by comarca,precioMin,nombre"; //echo "

voy a hacer select de la siguiente query: ". $sSql; $result=mysql_query($sSql, $comments_db_link); $comments_count=0; $contador=0; $contador_total=0; $fondo=0; $tempSeccion=""; $nombre=$direccion=$comarca=$poblacion=$precioMin=$precioMax=$identidad=array(); while (list($nombre[$comments_count], $direccion[$comments_count],$comarca[$comments_count],$poblacion[$comments_count],$precioMin[$comments_count],$precioMax[$comments_count],$identidad[$comments_count])=mysql_fetch_array($result)) { if (!is_null($nombre[$comments_count]) || $nombre[$comments_count]!=""){ if ($fondo==0){ echo ""; $fondo=1; }else{ echo ""; $fondo=0; } echo ""; echo ""; $zonaAux="Otra zona"; switch($comarca[$comments_count]){ case "0": $zonaAux="Soba - Asn valley"; break; case "1": $zonaAux="East Coast"; break; case "2": $zonaAux="Santander and nearby"; break; case "3": $zonaAux="Pas - Miera valley"; break; case "4": $zonaAux="Torrelavega -Besaya valley"; break; case "5": $zonaAux="West Coast"; break; case "6": $zonaAux="Saja - Nansa"; break; case "7": $zonaAux="Libana and Picos de Europa"; break; case "8": $zonaAux="Campoo and Valderredible"; break; default: $zonaAux="Other zone"; break; } echo ""; $precioAux="Indeterminado"; if($precioMin[$comments_count]==$precioMax[$comments_count]){ $precioAux="".$precioMin[$comments_count]." €"; }else{ $precioAux="".$precioMin[$comments_count]." - ".$precioMax[$comments_count]." €"; } echo ""; echo ""; $contador++; $contador_total++; } if ($contador==4){ echo ""; $contador=0; } $comments_count++; } if ($contador_total==0){ echo ''; } } //Quitar accentos y espacios de un texto.... function GetQuitarAcentos($s) { $s = ereg_replace("[]","a",$s); $s = ereg_replace("[]","A",$s); $s = ereg_replace("[]","I",$s); $s = ereg_replace("[]","i",$s); $s = ereg_replace("[]","e",$s); $s = ereg_replace("[]","E",$s); $s = ereg_replace("[]","o",$s); $s = ereg_replace("[]","O",$s); $s = ereg_replace("[]","u",$s); $s = ereg_replace("[]","U",$s); $s = str_replace("","c",$s); $s = str_replace("","n",$s); $s = str_replace("","N",$s); $s = str_replace("","C",$s); $s = str_replace(" ","_",$s); $s = str_replace("(","",$s); $s = str_replace(")","",$s); $s = str_replace("'","",$s); return strtolower($s); } ?>
Name Address Zone Average price
".utf8_encode($nombre[$comments_count])." ".utf8_encode($direccion[$comments_count])."
".utf8_encode($poblacion[$comments_count])."
".utf8_encode($zonaAux)."".$precioAux."


No restaurants found for the search criteria. Recommend us a restaurant
©1996-2012 Francisco Tazón Vega. All rights reserved