<?php
require "_admin/_globals.php";
require CLASS_MP_BUSINESS;
require CLASS_ADS;
$biz = new handleBusiness();
$catquery = mysql_query("SELECT * FROM `" . SD_TABLE_NAME . "` ORDER BY `category`;");
while ($catrec = mysql_fetch_assoc($catquery)) {
$sd_cats[$catrec[id]] = $catrec[category];
$order_cat .= " `sd_cat` = '" . $catrec[id] . "',";
}
$query = mysql_query("SELECT * FROM `" . MP_TABLE_NAME . "` WHERE `sd_cat` != '' ORDER BY " . $order_cat . " `business_name` ASC;");
while ($rec = mysql_fetch_assoc($query)) {
$business[$rec["sd_cat"]][] = $biz->cardSericeDirectory($rec);
}
if (is_array($sd_cats)) {
foreach ($sd_cats as $key => $value) {
if (is_array($business[$key])) {
$build_sd .= "<div class='sd-title'>" . $value . " - <a href=\"#top\" class=\"small white\">Back To Top</a><a name=\"" . $value . "\"></a></div>";
$build_cats .= "<a href=\"#" . $value . "\" class='medium'>" . $value . "</a>";
foreach ($business[$key] as $subkey => $card) {
$build_sd .= $card . "<br>";
}
}
}
}
$page_title = PAGETITLE . " Service Directory";
?>
<?php
getHeader("public", "yes");
