select count(*) as nbmbre from (select id,1 as importance,dateAjout,1 as is_vibiliteplus from membres_visibilite_plus where categorie = '' AND actif='1' and region=13 union select id,2 as importance,dateAjout,0 as is_vibiliteplus from membres_normaux where categorie = AND actif='1' and region=13 order by importance asc, id desc) as _DERIVED_TABLE
Array ( [type] => 1 [message] => Uncaught exception 'Exception' with message 'Erreur lors de l'execution d'une requête FICHIER : /home/quebect/classes/listingmembres.class.php LIGNE : 47 Requète fautive : select count(*) as nbmbre from (select id,1 as importance,dateAjout,1 as is_vibiliteplus from membres_visibilite_plus where categorie = '' AND actif='1' and region=13 union select id,2 as importance,dateAjout,0 as is_vibiliteplus from membres_normaux where categorie = AND actif='1' and region=13 order by importance asc, id desc) as _DERIVED_TABLE Erreur retounée : 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 'AND actif='1' and region=13 order by importance asc, id desc) as _DERIVED_TABLE' at line 1' in /home/quebect/classes/db.class.php:33 Stack trace: #0 /home/quebect/classes/listingmembres.class.php(47): db::query('select count(*)...', '/home/quebect/c...', 47) #1 [internal function]: listingmembres::loadListing('membres', 'Mauricie', 'Saguenay-L [file] => /home/quebect/classes/db.class.php [line] => 33 )une erreur de syntaxe : oups!