Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /var/www/domaines/www.liste-opticiens.com/lib/main.php on line 213 Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /var/www/domaines/www.liste-opticiens.com/lib/main.php on line 215 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 SELLERID DESC, POS, NOM' at line 1
SELECT ID, PUB, NOM, ADRESSE, CP, UCASE(VILLE) AS VILLE, TEL1, TEL2, FAX, EMAIL, LAT, LON, (case (endvalid is not null and endvalid0) when 1 then 0 else sellerID end) as SELLERID, COMMENT, FORSURFERS, replace(MARQUES,' ', '
') as MARQUES, web, replace(WAY,' ', '
') as WAY, replace(OPENHOUR,' ', '
') as OPENHOUR, replace(TIERS,' ', '
') AS TIERS from OPTICIENS WHERE HIDDEN=0 AND VILLE LIKE 'HAY LES ROSES (L')%' ORDER BY SELLERID DESC, POS, NOM