how to show out into multiple line in mysql?
my code is bellow
$sql=mysql_query("SELECT qualify_question.*,qulify_answar.*,GROUP_CONCAT(Answar_text SEPARATOR 'next')Answar_text FROM qualify_question, qulify_answar
WHERE qualify_question.Id = qulify_answar.Question_id
GROUP BY Question_text");
using this code out will show in this format
i.e. hhhhhh,hhhhhh,jjjjjjj,hhhhhh,
but i want to in this format like
i.e. hhhhhh
hhhhhh
jjjjjjjjjjjjj
hhhhhh
please help me.
thanks