how to show output into multiple line in php mysql?

May 30 2015 2:00 AM
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

Answers (1)