[résolu] Afficher des articles relatifs

More
13 years 2 months ago #18567 by ggppdk
Replied by ggppdk on topic [résolu] Afficher des articles relatifs
I think i forgot GROUP BY in query

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #18600 by micker
Replied by micker on topic [résolu] Afficher des articles relatifs
Merci pour Le retour
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #18608 by ggppdk
Replied by ggppdk on topic [résolu] Afficher des articles relatifs
Replace line:
Code:
. ' WHERE c.id = ' . $id;
with:
Code:
. ' WHERE c.id = ' . $id . ' GROUP BY ci.itemid';

AND ALSO change CONCAT_WS to GROUP_CONCAT_WS

I did not test but now it should work. If not i will find some time to test and correct this.

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #18615 by micker
Replied by micker on topic [résolu] Afficher des articles relatifs
tu nous tiens au courant apres tes tests flashfred ?
Merci
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #18682 by flashfred
Replied by flashfred on topic [résolu] Afficher des articles relatifs
Merci pour les réponses.

GROUP_CONCAT_WS me renvoie une erreur (n'existe pas...).

En cherchant un peu, j'ai remplacé par :
Code:
GROUP_CONCAT(ci.catid SEPARATOR ",")
Et... ça marche !!! :P

Merci beaucoup ggppdk ! Du très beau boulot, et réactif en plus.

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #18689 by micker
Replied by micker on topic [résolu] Afficher des articles relatifs
super pense que si c'est régler édite le titre de post et ajoute [résolu]
Merci
FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

Moderators: vistamedia, joomlacorner, ggppdk
Time to create page: 0.463 seconds

Last FLEXI-site

Last Faq articles

Newsletter

Last Tutos about FLEXIcontent

Login

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline