ERROR...<br><font style="color:red; font-size:18px; ">Mysql error1064: 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  date_add desc' at line 1

Array
(
    [PATH] => /usr/local/bin:/usr/bin:/bin
    [REDIRECT_STATUS] => 200
    [UNIQUE_ID] => zU8TuX8AAAEAABEY5lIAAAAD
    [MvCONFIG_LIBRARY] => /usr/local/miva/lib/config/env.so
    [MvCONFIG_DIR_BUILTIN] => /usr/local/miva/lib/builtins
    [MvCONFIG_DIR_CA] => /usr/local/miva/certs
    [MvCONFIG_SSL_OPENSSL] => /usr/lib/libssl.so
    [MvCONFIG_SSL_CRYPTO] => /usr/lib/libcrypto.so
    [MvCONFIG_DIR_MIVA] => /home/sites/mallorcavillasforsale.com/public_html
    [MvCONFIG_DIR_DATA] => /home/sites/mallorcavillasforsale.com/mivadata
    [HTTP_X_CC_ID] => ccc02-01
    [HTTP_HOST] => www.mallorcavillasforsale.com
    [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    [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
    [HTTP_COOKIE] => PHPSESSID=3f5bd4b5e887f0e400fd50b1d780862a
    [SERVER_SIGNATURE] => <address>Apache/2 Server at www.mallorcavillasforsale.com Port 80</address>

    [SERVER_SOFTWARE] => Apache/2
    [SERVER_NAME] => www.mallorcavillasforsale.com
    [SERVER_ADDR] => 79.170.40.166
    [SERVER_PORT] => 80
    [REMOTE_ADDR] => 38.107.191.92
    [DOCUMENT_ROOT] => /home/sites/mallorcavillasforsale.com/public_html/
    [SERVER_ADMIN] => webmaster@mallorcavillasforsale.com
    [SCRIPT_FILENAME] => /home/sites/mallorcavillasforsale.com/public_html/index.php
    [REMOTE_PORT] => 21543
    [REDIRECT_QUERY_STRING] => p=search&submit=1&province=Cala D'Or
    [REDIRECT_URL] => /property-for-sale-Cala D'Or.html
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => GET
    [QUERY_STRING] => p=search&submit=1&province=Cala D'Or
    [REQUEST_URI] => /property-for-sale-Cala%20D'Or.html
    [SCRIPT_NAME] => /index.php
    [PHP_SELF] => /index.php
    [argv] => Array
        (
            [0] => p=search&submit=1&province=Cala D'Or
        )

    [argc] => 1
)

SELECT COUNT(*) FROM `listing` WHERE active >= 1  and `province` = 'Cala D'Or'  ORDER BY  date_add desc;
: </font>