Herohill.com v5.2:: Real Rock From The Rocks <$BlogPageTitle$> <Blogger><$BlogItemTitle$></Blogger> - <$BlogTitle$> FRIDAY::
"; print ""; while ($db_field = mysql_fetch_assoc($result)) { print ""; print ""; print ""; print ""; } print "
  " . $db_field['Performers'] . "   @ "; print $db_field['Venue'] . ", "; print $db_field['ShowTime'] . "    "; print $db_field['Comments'] . "  
"; print "
"; $SQL = "SELECT ShowID, Performers, Venue, ShowDate, DATE_FORMAT( ShowDate, '%M %e, %Y' ) FormatShowDate, ShowTime, Comments, HHInTheHouse FROM ShowListings WHERE ShowDate > CURDATE( ) AND ShowDate < DATE_ADD( CURDATE( ) , INTERVAL 2 DAY ) ORDER BY ShowDate"; $result = mysql_query($SQL); print "SATURDAY::
"; print ""; while ($db_field = mysql_fetch_assoc($result)) { print ""; print ""; print ""; print ""; } print "
  " . $db_field['Performers'] . "   @ "; print $db_field['Venue'] . ", "; print $db_field['ShowTime'] . "    "; print $db_field['Comments'] . "  
"; print "
"; $SQL = "SELECT ShowID, Performers, Venue, ShowDate, DATE_FORMAT( ShowDate, '%M %e, %Y' ) FormatShowDate, ShowTime, Comments, HHInTheHouse FROM ShowListings WHERE ShowDate >= DATE_ADD( CURDATE( ) , INTERVAL 2 DAY ) AND ShowDate < DATE_ADD( CURDATE( ) , INTERVAL 7 DAY ) ORDER BY ShowDate"; $result = mysql_query($SQL); print "NEXT WEEK::
"; print ""; while ($db_field = mysql_fetch_assoc($result)) { print ""; print ""; print ""; print ""; } print "
"; print $db_field['FormatShowDate']; print " " . $db_field['Performers'] . "   @ "; print $db_field['Venue'] . ", "; print $db_field['ShowTime'] . "    "; print $db_field['Comments'] . "  
"; mysql_close($db_handle); } else { print "Database NOT Found "; mysql_close($db_handle); } ?>