Sei in Giungano

total queries: 3 (0.00074291229248047 seconds) successful queries: 2 unsuccessful queries : 1 messages : 0 watch: 0 globals
»
1.
  
SELECT
SQL_CALC_FOUND_ROWS Id, Nome, Indirizzo, Localita, LocalitaNorm, Telefono, Provincia , Rif_Tipo
FROM
Aziende
WHERE
Localita = 'Giungano' AND Rif_Tipo =
ORDER BY
Nome

mySQL error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY Nome' at line 6
function: query
file: /web/htdocs/www.tourincampania.com/home/elenco/elencolocali.php
line: 66
close all
1.
  
SELECT
SQL_CALC_FOUND_ROWS Provincia, Localita
FROM
Aziende
WHERE
LocalitaNorm = 'giungano'
limit
1

execution time: 0.00051689147949219 seconds
returned rows: 1 «« show | explain
function: query
file: /web/htdocs/www.tourincampania.com/home/elenco/elencolocali.php
line: 15
close all
2.
  
SELECT
SQL_CALC_FOUND_ROWS P.Rif_Tipo as Id, P.Parola as Descrizione, T.Testo
FROM
Parole_Chiavi P JOIN Tipologie T ON T.Id = P.Rif_Tipo
WHERE
P.ParolaNorm = 'bedandbreakfast'

execution time: 0.00022602081298828 seconds
returned rows: 0 «« show | explain
function: query
file: /web/htdocs/www.tourincampania.com/home/elenco/elencolocali.php
line: 26
close all
messages: 0
close all
watch: 0
$_COOKIE $_FILES $_GET $_POST $_SERVER $_SESSION
$_FILES
Array
(
)
                
close all
$_GET
Array
(
    [tipo] => bedandbreakfast-giungano
)
                
close all
$_POST
Array
(
)
                
close all
$_SERVER
Array
(
    [PATH] => /usr/local/bin:/usr/bin:/bin
    [REDIRECT_STATUS] => 200
    [UNIQUE_ID] => SSe3Hn8AAAEAABqKpBwAAAB9
    [HTTP_HOST] => www.tourincampania.com
    [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
    [HTTP_ACCEPT] => Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
    [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
    [HTTP_ACCEPT_ENCODING] => gzip
    [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
    [HTTP_CONNECTION] => close
    [HTTP_CACHE_CONTROL] => no-cache
    [HTTP_PRAGMA] => no-cache
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache/2.2
    [SERVER_NAME] => www.tourincampania.com
    [SERVER_ADDR] => 62.149.140.83
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 38.103.63.61
    [DOCUMENT_ROOT] => /web/htdocs/www.tourincampania.com/home/
    [SERVER_ADMIN] => postmaster@tourincampania.com
    [SCRIPT_FILENAME] => /web/htdocs/www.tourincampania.com/home/elenco/elencolocali.php
    [REMOTE_PORT] => 57184
    [REDIRECT_QUERY_STRING] => tipo=bedandbreakfast-giungano
    [REDIRECT_URL] => /elenco/bedandbreakfast-giungano/
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => tipo=bedandbreakfast-giungano
    [REQUEST_URI] => /elenco/bedandbreakfast-giungano/
    [SCRIPT_NAME] => /elenco/elencolocali.php
    [PHPRC] => 
    [PHP_SELF] => /elenco/elencolocali.php
)
                
close all
$_SESSION
                
close all