PHP & Mysql Code only outputting one subcategory

[ade234uk]

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>"; 
}

[ade234uk]

Sorry double post

[Barand]

You mean "ORDER BY" and not "GROUP BY"

 

GROUPis for aggregating results to a one row summary.