how to show output into multiple row in mysql?

11y1.1kPHP

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

2 Replies

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

Upendra Pratap Shahi11y ago
select
ordered_item.id as `Id`,
ordered_item.Item_Name as `ItemName`,
GROUP_CONCAT(Ordered_Options.Value) as `Options`
from
ordered_item,
ordered_options
where
ordered_item.id=ordered_options.ordered_item_id
group by
ordered_item.id

read below link-

http://stackoverflow.com/questions/24533099/multiple-rows-output-into-variables-in-mysql

mark the answer as Accepted Answer if helpful
0
Syed Shanu11y ago
you can use the union to get bot the result in row wise.but both query should have equal no of column and column names for example you can try like this.
select Question_text as 'Text' FROM qualify_question where yourcondition='yourcondition'group by Question_text
Union

select Question_text as 'Text' FROM qulify_answar where yourcondition='yourcondition'Group by Question_text
0