';
echo 'Category Index';
echo '';
// Select merchant data if they are in the section
while ($rowK = mysql_fetch_array($resultK)) {
$colnumber++;
if ($colnumber > 5) {
$colnumber = 1;
}
switch ($colnumber) {
case 1:
printf(' | %c',$rowK["section"],$rowK["section"],13);
break;
case 2:
printf(' | %c',$rowK["section"],$rowK["section"],13);
break;
case 3:
printf(' | %c',$rowK["section"],$rowK["section"],13);
break;
case 4:
printf(' | %c',$rowK["section"],$rowK["section"],13);
break;
case 5:
printf(' | %c',$rowK["section"],$rowK["section"],13);
break;
}
}
echo '
';
// Get the sections from the sections table
$resultA = mysql_query ("SELECT section,malls FROM sections Where status=1 And malls like '%br%' ORDER BY section");
// Select merchant data if they are in the section
while ($rowA = mysql_fetch_array($resultA)) {
$section = $rowA["section"];
printf('%c',$rowA["section"],13);
printf('%s
%c',$rowA["section"],13);
$resultB = mysql_query ("SELECT * FROM bizdir Where malls like '%br%' And status = '1' ORDER BY priority,sortname");
while ($rowB = mysql_fetch_array($resultB)) {
// do not include entries that are not from the mall
$malls = $rowB["malls"];
if (stristr($malls,'br') AND stristr($rowB["sections"],$section)) {
printf('%c',$rowB["account"],13);
// Do we have a logo
if ($rowB["logo"] != "") {
printf('%c %c',13,$rowB["company"],13);
echo '';
printf(' %c%c | %c',13,13,$rowB["logo"],$rowB["logowidth"],$rowB["logoheight"],13);
printf(' %s | %c',$rowB["company"],13);
printf('
%c',13);
if ($rowB["slogan"] != "") {
printf('%s
|
%c',$rowB["slogan"],13);
}
printf('
%c',13);
} else {
echo '';
printf('%s |
%c',$rowB["company"],13);
if ($rowB["slogan"] != "") {
printf('%s |
%c',$rowB["slogan"],13);
} else {
echo "
";
}
printf('
%c',13);
}
printf ('%s',$rowB["listing"]);
if ($rowB["phone"] != "") {
printf ('Phone: %s %c',$rowB["phone"],13);
}
if ($rowB["fax"] != "") {
printf ('Fax: %s %c',$rowB["fax"],13);
}
if ($rowB["tollfree"] != "") {
printf ('Tollfree: %s%c',$rowB["tollfree"],13);
}
echo '
';
if ($rowB["email"] != "") {
printf ('Email: %s%c',$rowB["email"],$rowB["email"],13);
echo '
';
}
if ($rowB["fullad"] != "") {
printf('Click Here For More Info...%c',$rowB["fullad"],13);
}
if ($rowB["map"] != 0) {
if ($rowB["map"] == 1) {
printf('
%c',$rowB["account"],13);
} else {
printf('',$rowB["account"]);
//
}
}
echo '
';
}
}
printf('Category Index%c',13);
}
?>