get all records by records type mysql table : i have a table like this
<pre>

list_type      list_name
----------     ---------
city            Chicago
city            Houston
city            Philadelphia
city            Phoenix
state           Alabama
state           Alaska
state           California
state           Connecticut
state           Delaware
state           Florida
state           Georgia
color           Red
color           Green
color           Blue
</pre>


when i run a mysql query, i need output like this 
<b>without using of GROUP_CONCAT</B>


<PRE>

list_type      list_name
----------     ---------
city         Chicago,Houston,Philadelphia,Phoenix         
state        Alabama,Alaska,California,Connecticut,Delaware,Florida,Georgia     
color        Red,Green,Blue
</PRE>
