-
Relax by the lake -
Bumper Boats -
Boating Events -
Morning at the beach -
CNY Vet Show -
Rides for the Young -
Sailing at Sunset -
Craft & Vendor Shows
\n";
switch($_REQUEST['type']){
case 'menu':
echo "\n\t \n\tMenus \n\t \n \n";
$query = mysql_query ("SELECT pdf.InfoType, pdf.BusId, pdf.PDFName, Business.BusTitle FROM pdf INNER JOIN Business ON pdf.BusId = Business.BusId and pdf.InfoType=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]." ";
}
}
break;
case 'brochure':
echo "\n\t \n\tBrochures \n\t \n \n";
$query = mysql_query ("SELECT pdf.InfoType, pdf.BusId, pdf.PDFName, Business.BusTitle FROM pdf INNER JOIN Business ON pdf.BusId = Business.BusId and pdf.InfoType=2 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]." ";
}
}
break;
default:
echo "\n\t \n\tMenus \n\t \n \n";
$query = mysql_query ("SELECT pdf.InfoType, pdf.BusId, pdf.PDFName, Business.BusTitle FROM pdf INNER JOIN Business ON pdf.BusId = Business.BusId and pdf.InfoType=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]." ";
}
}
}
echo "";
?>