'TNG' "; $rsShows=mysql_query($query); $numRows=mysql_numrows($rsShows); // OLD CODE echo ""; // *** START CALENDAR *** echo "
"; // put link to Previous Month, Next Month and BOLD THIS MONT echo ""; echo ""; echo ""; // put headers for Each Day of The Week echo ""; foreach($daysOfWeek as $day) { echo ""; } echo ""; // put the spaces before the first day of the week in echo ""; $currentDay = 1; if ($dayOfWeek > 0) { echo ""; } // step through each day of the month while ($currentDay <= $noDays) { if ($dayOfWeek == 7) { $dayOfWeek = 0; echo ""; } // make the date in the calendar echo ""; // skip to next day $currentDay++; $dayOfWeek++; } // if there are days left in the week, fill out the row if ($dayOfWeek != 7) { $remainingDays = 7 - $dayOfWeek; $calendar .= ""; // echo ""; // echo ""; // echo ""; $intCount++; } // skip to next day // close the table ?>

" . $PrevMonthName . "

" . $displayMonthSpelled . " " . $displayYear . "

" . $NextMonthName . "

$day

" . $currentDay . "

"; // see if there is a show this date // grab the recordset for THIS month mysql_select_db ("challie_Bigfellas"); $dateFormat = date("Y/m/d", mktime(0,0,0, $displayMonth, $currentDay, $displayYear)); $query="SELECT * FROM Shows WHERE WhoPlaying <> 'TNG' AND Date = '" . $dateFormat . "'" ; $rsShows=mysql_query($query); $numRows=mysql_numrows($rsShows); // if there is a show on this date, get the info if ($numRows > 0) { $showID=mysql_result($rsShows,0,"ID"); $showVenue=mysql_result($rsShows,0,"Club"); $showTime=mysql_result($rsShows,0,"Time"); $showAddress=mysql_result($rsShows,0,"Address1"); $showCity=mysql_result($rsShows,0,"City"); $showState=mysql_result($rsShows,0,"State"); $showZip=mysql_result($rsShows,0,"Zip"); $showMap=mysql_result($rsShows,0,"Map"); $showVenueURL=mysql_result($rsShows,0,"URL"); $showCover=mysql_result($rsShows,0,"Cover"); $showWho=mysql_result($rsShows,0,"WhoPlaying"); $showOtherBands=mysql_result($rsShows,0,"OtherBands"); $showNotes=mysql_result($rsShows,0,"ShowNotes"); // display the info // fix this for pop link soon // echo ""; // $showID . "' >" . $showVenue . "
"; echo ""; // put venue - if there is a URL for the venue/show then make it as a link if ($showVenueURL == "") echo $showVenue; else { echo " " . $showVenue . ""; } echo "
"; // if special lineup (like Charlie only) - put here if ($showWho == "Charlie") { echo ''; if ($showOtherBands == "") { echo 'Charlie solo
'; } else { echo 'Charlie w/ ' . $showOtherBands . '
'; } } if ($showWho == "Release") { echo '>'; echo 'Our CD Release Party!
'; } if (!strncasecmp($showWho, 'w/', 2)){ echo ''; echo 'with ' . $showOtherBands . '
'; } echo "" . $showCity; if ($showState <> "CA") { echo ", " . $showState; } echo ""; // if there's a map, include the link if ($showMap <> "") { if (!strncasecmp($showMap, 'RADIO', 5)){ echo " " . "Listen"; } else { echo " " . "Map"; } } echo "
"; echo "" . $showTime . "
"; } // end this days cell echo "

"; // echo "

"; // echo "" . $displayDate . "
"; // echo "" . $showTime . ", " . $NEWshowCover . "
"; // echo "

"; // echo "" . $showVenue . "
"; // echo $showAddress . " - " . $showCity . ", " . $showState . " " . $showZip . "
"; // echo "
"; // echo "" . $showNotes . "
"; // echo "