how to show output into multiple row in mysql?

May 29 2015 9:49 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 (2)