Loading

how to show output into multiple line in php mysql?

11y950PHP

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
I have suggest to do below work for better result
1-Split ',' from result set and put this value in array
2-Then print array by index in a loop with appending '
' tag in the last of result set in loop.

If you agree with my answer kindly accept the answer for better discussion on forum...
0