I just realized that my namings sound so wrong in English. sex_candidati reffers to the gender of the candidates, I'm not making anything naughty here :D
seularts
0
Light Poster
diafol
How are your ordering this? $p1/$p2 (whetever that is) or none at all? You can put
ORDER BY 1inside the GROUP_CONCAT:
GROUP_CONCAT(DISTINCT(lb.limba) ORDER BY 1 SEPARATOR ', ')Do check if you actually need the distinct in every case.
seularts
0
Light Poster
Sweet that did the trick ^_^ . $p1 and $p2 are to ordering filters I set for various nefarious purposes :D Thanks a bunch, my lil' data base is starting to get an awesome shape!
Web-Designer
0
Web Designer Singapore
Too many sub queries - Performance may get affected!!
Check it out!!
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.