1.


SELECT
SQL_CALC_FOUND_ROWS city
FROM
locations
WHERE
REPLACE(city, ' ','')='REDONDOBEACH'
GROUP BY
primary_city
LIMIT
1

MySQL error message: Unknown column 'primary_city' in 'group statement'

Backtrace Full trace

function: query
file: /home/drtaddie/public_html/classes/dist_class.php
line: 126

close all

successful queries: 0

message: Don't forget to explicitly call the close() method at the end of your script. This can be a life saver if you have heavy traffic and frequent queries

method: close()

close all

watch: 0

$_COOKIE $_FILES $_GET $_POST $_SERVER $_SESSION

$_FILES

Array
(
)
                

$_GET

Array
(
)
                

$_POST

Array
(
)
                

$_SERVER

Array
(
    [SERVER_SOFTWARE] => Apache
    [REQUEST_URI] => /locations/redondobeachca.html/
    [CONTEXT_DOCUMENT_ROOT] => /home/drtaddie/public_html
    [CONTEXT_PREFIX] => 
    [DOCUMENT_ROOT] => /home/drtaddie/public_html
    [GATEWAY_INTERFACE] => CGI/1.1
    [HTTPS] => on
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_ACCEPT_ENCODING] => x-gzip, gzip, deflate
    [HTTP_HOST] => www.lbgenetics.com
    [HTTP_USER_AGENT] => CCBot/2.0 (http://commoncrawl.org/faq/)
    [HTTP_X_HTTPS] => 1
    [PATH] => /bin:/usr/bin
    [QUERY_STRING] => 
    [REDIRECT_HTTPS] => on
    [REDIRECT_SCRIPT_URI] => https://www.lbgenetics.com/locations/redondobeachca.html/
    [REDIRECT_SCRIPT_URL] => /locations/redondobeachca.html/
    [REDIRECT_SSL_TLS_SNI] => www.lbgenetics.com
    [REDIRECT_STATUS] => 200
    [REDIRECT_UNIQUE_ID] => WeuDwYqAtSIAAC3LwI0AAAAJ
    [REDIRECT_URL] => /locations/redondobeachca.html/
    [REMOTE_ADDR] => 54.196.72.162
    [REMOTE_PORT] => 45542
    [REQUEST_METHOD] => GET
    [REQUEST_SCHEME] => https
    [SCRIPT_FILENAME] => /home/drtaddie/public_html/index.php
    [SCRIPT_NAME] => /index.php
    [SCRIPT_URI] => https://www.lbgenetics.com/locations/redondobeachca.html/
    [SCRIPT_URL] => /locations/redondobeachca.html/
    [SERVER_ADDR] => 138.128.181.34
    [SERVER_ADMIN] => webmaster@lbgenetics.com
    [SERVER_NAME] => www.lbgenetics.com
    [SERVER_PORT] => 443
    [SERVER_PROTOCOL] => HTTP/1.0
    [SERVER_SIGNATURE] => 
    [SSL_TLS_SNI] => www.lbgenetics.com
    [TZ] => America/New_York
    [UNIQUE_ID] => WeuDwYqAtSIAAC3LwI0AAAAJ
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1508606913.29
    [REQUEST_TIME] => 1508606913
    [argv] => Array
        (
        )

    [argc] => 0
)
                

$_SESSION

Array
(
)