lilougirl8 | Bonjour,
Voilà j'ai un problème assez etrange, ma requete marche en local mai pas en ligne...enfin, en ligne, il me met 0 a tous mes résultats ce qui est bien évidemant pas le cas...
Voila ma requete
Code :
- $sql = "SELECT COUNT(DISTINCT h.ID) AS nb_histoire, COUNT(DISTINCT c.ID) AS nb_cours, COUNT(DISTINCT l.ID) AS nb_def, ";
- $sql .= "COUNT(DISTINCT n.ID) AS nb_news, COUNT(DISTINCT f.ID) AS nb_film, COUNT(DISTINCT s.ID) AS nb_serie, ";
- $sql .= "COUNT(DISTINCT e.ID) AS nb_ecole, COUNT(DISTINCT b.ID) AS nb_boutique, COUNT(DISTINCT d.ID) AS nb_disco, ";
- $sql .= "COUNT(DISTINCT w.images_ID) AS nb_wallpaper, COUNT(DISTINCT i.images_ID) AS nb_image ";
- $sql .= "FROM histoire AS h, cours AS c, lexique AS l, news AS n, films AS f, serie_tv AS s ";
- $sql .= "LEFT JOIN professionnels AS e ON e.pro_nature = 'ecole' ";
- $sql .= "LEFT JOIN professionnels AS b ON b.pro_nature = 'boutique' ";
- $sql .= "LEFT JOIN professionnels AS d ON d.pro_nature = 'discotheque' ";
- $sql .= "LEFT JOIN images AS w ON w.images_rubrique_nom = 'wallpaper' ";
- $sql .= "LEFT JOIN images_rubriques AS r ON r.rubrique_sous_rubrique NOT IN('films', 'series') ";
- $sql .= "LEFT JOIN images AS i ON i.images_rubrique_nom = 'photos' AND i.images_type = 'mini' AND i.images_rubrique_ID = r.rubrique_ID ";
|
auriez vous une idée de ce qui ne va pas?
Merci a tous |
