Jluis Posted October 29, 2021 Share Posted October 29, 2021 Hello , je voudrais afficher un retour à la ligne aprés l'affichage d'une caractériqtue : value au niveau de cette requeté sql ci-dessous non requête sql SELECT `fp`.`id_product` AS 'ID', p.reference AS 'REFERENCE', p.active AS 'Actif', group_concat(DISTINCT( concat_ws(' ',fl.`NAME`,':',fvl.`value`)) SEPARATOR "\r\n") AS `features` FROM co_product p LEFT JOIN co_product_lang pl ON ( p.id_product = pl.id_product ) LEFT JOIN co_feature_product fp ON ( fp.id_product = p.id_product ) LEFT JOIN co_feature_lang fl ON ( fl.id_feature = fp.id_feature AND fl.id_lang = 1 ) LEFT JOIN co_feature_value_lang fvl ON ( fvl.id_feature_value = fp.id_feature_value ) WHERE pl.id_lang = 1 GROUP BY `p`.`id_product` ORDER BY `Actif` ASC Un idée svp ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now