Wow
the new album comes out tomorrow. It seems like just yesterday when the last one came out....
*zachtipton*
Monday, October 15, 2007
Previous Posts
- Another new song is up
- Posters! Crap!
- NEW SINGLE
- Finally
- Tour this fall
- Superbad
- A second beat!
- HELP ME!!!
- I Am Playing An Acoustic Show
- The record is mixed!
On Tour
-
sqlQuery("SELECT TOP 10 show_date=DATEDIFF(s,'19691231',s.ShowDate), s.SupportingActs, s.RecordID, v.VenueName, v.VenueCity, v.VenueState, v.VenueCountry FROM SHOWS_ALL s, SHOWS_VENUES v WHERE s.ArtistID = '$artist_id' AND s.ShowDate >= '$now_time' AND v.VenueID = s.VenueID ORDER BY s.ShowDate");
foreach($results as $res){
$date = date("M j", $res['show_date']);
$city_state = $res['VenueCity'].", ".$res['VenueState'];
$venue = $res['VenueName'];
$acts = $res['SupportingActs'];
if(empty($acts)){
$acts = " ";
}
?>
- - -
- View All Dates
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home