All Craftsmen Directory
";
foreach($alpha as $a){
$u = strtoupper($a);
$sql = mysql_query("select * from company_reviews where display_name like '$a%' order by display_name", $db);
$num = mysql_num_rows($sql);
if($num != 0){
$quick[] = $u;
$run_num = $run_num+$num;
$print_bit .= "
$u
";
while($arr = mysql_fetch_array($sql)){
$seo_file = $doc_root."reviews/".urlencode(str_replace(" ", "_", str_replace("/", "-", $arr[display_name])."_".str_replace(",", "", $arr[rough_address])))."/$arr[id].htm";
$print_bit .= "- $arr[display_name]
$arr[rough_address] \n";
}
$print_bit .= "
\n";
if($run_num>$third){
$print_bit .= " | ";
$run_num = 0;
}
}
}
$print_bit .= " |
";
foreach($quick as $q){
$q_bits[] = "
$q";
}
echo "
".implode(" - ", $q_bits)."";
echo $print_bit;
?>