\n";
echo "\n\t \n\tOur Members \n\t \n \n";
switch($_REQUEST['type']){
case 'alpha':
$query = mysql_query ("SELECT BusTitle, CatId, SpInfo FROM Business WHERE CatId<>3 AND CatId<10 AND SpInfo!= 1 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
while ($row = mysql_fetch_array ($query)) {
$i++;
if ($i % 3==1) {
echo "\n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
break;
case 'group':
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=1 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Attractions \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=2 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Camping \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=4 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Lodging \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=5 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Dining \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=6 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Services \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=7 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Shops & Stores \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=9 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Marinas \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
$query = mysql_query ("SELECT Business.BusTitle, Business.CatID, Catagory.CatDesc FROM Business INNER JOIN Catagory ON Business.CatID=Catagory.CatID WHERE Catagory.CatID=8 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
echo "Sponsors \n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
break;
default:
$query = mysql_query ("SELECT BusTitle, CatId, SpInfo FROM Business WHERE CatId<>3 AND CatId<10 AND SpInfo!= 1 ORDER by BusTitle");
$num_rows = mysql_num_rows($query);
while ($row = mysql_fetch_array ($query)) {
$i++;
if ($i % 3==1) {
echo "\n".$row[BusTitle]." ";
if ($i==$num_rows) {
echo " ";
}
}else if ($i % 3==2) {
echo "".$row[BusTitle]." ";
if ($i==$num_rows) {
echo "".$row[BusTitle]." \n\n";
}
}
}
echo "";
?>