this is for people who don't realize there are other things going on in this world.
Friday, October 19, 2007
Previous Posts
- WAKE UP
- Wow
- Another new song is up
- Posters! Crap!
- NEW SINGLE
- Finally
- Tour this fall
- Superbad
- A second beat!
- HELP ME!!!
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