Related links:

"; $tsorter= array(); $counter= array(); while($row = mysql_fetch_object($q)){ $town = ucwords(trim(strtolower(str_replace('-', ' ', $row->townname))));//get rid of white space, allow for different capitalisation and hyphens/spaces $tsorter["$row->Name"]["$town"][] = $row->EstType;//create multi dimensional array of towns with all possible est types $counter[] = $town; } $counter = array_unique($counter); $count = 0; $num = floor(count($counter)/2); foreach($tsorter as $key => $trow){ if($count >= $num && !isset($stop)){ echo'

'; $stop = 1; } echo"$key
\n"; foreach($trow as $key =>$row){ echo'$key
\n";} elseif(in_array(2, $row)){echo"bnbtowns.cfm?town=".rawurlencode($key)."&county=$county'>$key
\n";} elseif(in_array(4, $row) || in_array(15, $row)){echo"selfctowns.cfm?town=".rawurlencode($key)."&county=$county'>$key
\n";} elseif(in_array(7, $row) ){echo"budgettowns.cfm?town=".rawurlencode($key)."&county=$county'>$key
\n";} else{echo"county$county/townguide".rawurlencode($key)."/'>$key
\n";} $count ++; } } echo '