ade234uk Posted September 7, 2012 Share Posted September 7, 2012 Wondering if any one could help. I am outputting all the Categories and Subcategories from MySQL. The problem I have is that my code is only displaying one subcategory , when It needs to display all subcategories from the parent. Output should be: Channel Islands Alderney Guernsey Jersey East Anglia (Eastern England) Bedfordshire Cambridgeshire Essex Hertfordshire Norfolk Suffolk and so on...... What is currently being outputted is: Channel Islands Alderney East Anglia (Eastern England) Bedfordshire Here is my mysql code below: $result = mysql_query("SELECT a.region_id, a.region_name, b.county_id, b.county_name FROM regions a LEFT JOIN counties b ON a.region_id = b.county_id GROUP BY region_id ORDER BY region_name"); while ( $row_region = mysql_fetch_array($result) ) { echo"<li><a href=\"\" class=\"link_one\">". $row_region['region_name'] ."</a>"; echo"<ul>"; echo"<li><a href=\"1.1\">". $row_region['county_name'] ."</a></li>"; echo"</ul></li>"; } Quote Link to comment Share on other sites More sharing options...
ade234uk Posted September 7, 2012 Author Share Posted September 7, 2012 Sorry double post Quote Link to comment Share on other sites More sharing options...
Barand Posted September 7, 2012 Share Posted September 7, 2012 You mean "ORDER BY" and not "GROUP BY" GROUPis for aggregating results to a one row summary. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.