'; print ""; } function PrintSideAd(){ print ' '; } function ConnectToDB() { $dbh=mysql_connect ("localhost", "rockmusi_mtype", "7Y#3;d1^13Lj") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("rockmusi_mt"); } function PrintMerch($artista='',$artistb='',$artistc='') { if($artista != ''){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artista' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if($result != '') { ?>
Related Merch:
"; } } // end artista if($artistb != 0){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artistb' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if ($result) { print ""; } while($myrow = mysql_fetch_array($result)) { ?> "; } } // end artistb if($artistc != 0){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artistc' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if ($result) { print ""; } while($myrow = mysql_fetch_array($result)) { ?> "; } } // end artistc if(($artista != '')) { ?>






"; } else if($imgurl == "0") { print ""; } else { if($url == "x"){ $url = $imgurl; } copy($url,$tempfile); $img = imagecreatefromjpeg( $tempfile ); // Get image size and scale ratio $width = imagesx($img); $height = imagesy($img); $scale = min($w/$width, $h/$height); // If the image is larger than the max shrink it if ($scale < 1) { $new_width = floor($scale*$width); $new_height = floor($scale*$height); // Create a new temporary image $tmp_img = imagecreatetruecolor($new_width, $new_height); // Copy and resize old image into new image imagecopyresampled($tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height); imagedestroy($img); $img = $tmp_img; // store image to server if(!@imagejpeg($tmp_img,$filename,85)){ echo "error saving jpeg."; exit; } // update database $sql = "UPDATE `mt_" . $type . "` SET `" . $type . "_" . $w . "` = \"" . $fileurl . "\" WHERE `" . $type . "_id` = $id LIMIT 1"; $result = mysql_query($sql); print "\"\"/"; } // scale < 1 } } } function DateDropDown($size=90,$default="DropDate") { // $size = the number of days to display in the drop down // $default = Todays date in m:d:Y format (SEE DATE COMMAND ON WWW.PHP.NET) // $skip = if set then the program will skip Sundays and Saturdays $skip=1; echo "\n"; } function StoreAlbumInfo($id,$link,$label,$rdate,$asin=0){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_link'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_link` = \"" . $link . "\" WHERE `album_id` = '$id' LIMIT 1"); } if($myrow['album_label'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_label` = \"" . $label . "\" WHERE `album_id` = '$id' LIMIT 1"); } if($myrow['album_date'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_date` = \"" . $rdate . "\" WHERE `album_id` = '$id' LIMIT 1"); } if($myrow['album_ASIN'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_ASIN` = \"" . $asin . "\" WHERE `album_id` = '$id' LIMIT 1"); } } } function StoreAlbumASIN($id,$asin){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_fetch_array(mysql_query($sql)); if($result['album_ASIN'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_ASIN` = \"" . $asin . "\" WHERE `album_id` = '$id' LIMIT 1"); } } function PrintAlbumLink($id,$link){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_link'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_link` = \"" . $link . "\" WHERE `album_id` = '$id' LIMIT 1"); print $link; } else { print $myrow['album_link']; } } } function PrintAlbumLabel($id,$label){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_label'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_label` = \"" . $label . "\" WHERE `album_id` = '$id' LIMIT 1"); print $label; } else { print $myrow['album_label']; } } } function PrintAlbumDate($id,$rdate){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_date'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_date` = \"" . $rdate . "\" WHERE `album_id` = '$id' LIMIT 1"); print $rdate; } else { print $myrow['album_date']; } } } function PrintAuthor($authorname,$authornick){ $imgurl = "/images/staff/" . $authorname . "_60.jpg"; $serverimg = "/home/rockmusi/public_html" . $imgurl; print ""; if(file_exists($serverimg)){ print ""; } print $authornick . ""; $result = mysql_query("SELECT stafftitle FROM `mt_author` WHERE author_name = '$authorname'"); $row = mysql_fetch_row($result); print "
" . $row[0] . ""; } function PrintAuthorNameLink($id){ $result = mysql_query("SELECT entry_author_id FROM `mt_entry` WHERE entry_id = '$id'"); $rowa = mysql_fetch_row($result); $result = mysql_query("SELECT author_id, author_name, author_nickname FROM `mt_author` WHERE author_id = '$rowa[0]'"); $row = mysql_fetch_row($result); print "" . $row[2] . ""; } function array_sort($array, $key) { for ($i = 0; $i < sizeof($array); $i++) { $sort_values[$i] = $array[$i][$key]; } asort ($sort_values); reset ($sort_values); while (list ($arr_key, $arr_val) = each ($sort_values)) { $sorted_arr[] = $array[$arr_key]; } return $sorted_arr; } function array_rsort($array, $key) { for ($i = 0; $i < sizeof($array); $i++) { $sort_values[$i] = $array[$i][$key]; } rsort ($sort_values); reset ($sort_values); while (list ($arr_key, $arr_val) = each ($sort_values)) { $sorted_arr[] = $array[$arr_key]; } return $sorted_arr; } function HeadStuff($section,$title,$desc){ ?> <? if($title){ print $title . " / "; } ?> <? if($section) { print $section . " / "; } ?>Rock Music Review =$today) && ($resulta['date'] <=$week)){ print "" . $theartist . " is currently on tour..."; return; } else if($resulta['date'] >=$today) { print "" . $theartist . " tour dates..."; return; } } } if (!function_exists('virtual')) { function virtual($file){ include("/home/rockmusi/public_html/$file"); } } if (!function_exists('mb_strtolower')) { function mb_strtolower($a){ return strtolower($a); } } ?> 0) { ?>
With all the solid music released in 2007, RMR thought that we would allow certain staffers to contribute their top albums of this year individually rather than collectively. These lists promise to offer unbridled opinions, rampant variety, and opportunities...
0) { ?>
Dope Pope, King Self, and Negashi Armada are living a dream as Supreeme, a rap group consisting of three Atlanta natives recently drafted to Warner Bros. Records from the California based indie Record Collection.
0) { ?>
GB Leighton is probably Minnesota’s best kept secret. Brian Leighton, the front man for the band, has been playing clubs in the Minneapolis region for almost a decade and a half, drawing huge crowds from an ever growing loyal fan base. He’s also one of the most productive songwriters coming out of the Twin Cities. His concerts are high octane parties that get people up and out of their seats, dancing and singing along.
0) { ?>
For over three decades, America has been writing and touring, making it one of the longest running country rock phenomenons in the world. The band currently is touring to support their latest recording, Here and Now, that is a very forward-looking venture, produced in collaboration with indie artists Adam Schlessinger from Fountains of Wayne, and James Iha of Smashing Pumpkins. They also will be touring with Chicago later this summer.
0) { ?>
“Death Threat,” “Warrior,” “Vampire,” “Piston,” “Danger Girl,” “Headhunter,” “Aggressor.” There’s a common link between all of these DJ Hive track titles, and that link is his mantra and record label: Violence.
">
">
">
">
">
"; } ?> ">Chk Chk Chk
"; } ?> ">Ahab Rex
"; } ?> ">Alias & Tarsier
"; } ?> ">Arrah & the Ferns
"; } ?> ">Beach House
"; } ?> ">Beastie Boys
"; } ?> ">Black Lips
"; } ?> ">Brand New
"; } ?> ">Consequence
"; } ?> ">Copeland
"; } ?> ">Dat'r
"; } ?> ">Deer Tick
"; } ?> ">Deerhoof
"; } ?> ">Dirty on Purpose
"; } ?> ">Dntel
"; } ?> ">Emily Haines & the Soft Skeleton
"; } ?> ">Enon
"; } ?> ">Fall Out Boy
"; } ?> ">Feist
"; } ?> ">Forgive Durden
"; } ?> ">Grinderman
"; } ?> ">Harley Poe
"; } ?> ">Isobel Campbell
"; } ?> ">Kanye West
"; } ?> ">Ladyhawk
"; } ?> ">Loch Lomond
"; } ?> ">Menomena
"; } ?> ">Modest Mouse
"; } ?> ">My Chemical Romance
"; } ?> ">Novi Split
"; } ?> ">Radiohead
"; } ?> ">Rufus Wainwright
"; } ?> ">Sean Lennon
"; } ?> ">Sonic Youth
"; } ?> ">Spoon
"; } ?> ">St. Vincent
"; } ?> ">Straylight Run
"; } ?> ">Supreeme
"; } ?> ">Tech N9ne
"; } ?> ">Tegan and Sara
"; } ?> ">The Decemberists
"; } ?> ">The Go! Team
"; } ?> ">The Good The Bad and The Queen
"; } ?> ">The New Pornographers
"; } ?> ">The Polyphonic Spree
"; } ?> ">The Rosebuds
"; } ?> ">The Shins
"; } ?> ">The Used
"; } ?> ">Under the Influence of Giants
"; } ?> ">Unkle
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Chk Chk Chk
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Ahab Rex
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Alias & Tarsier
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Arrah & the Ferns
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Beach House
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Beastie Boys
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Black Lips
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Brand New
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Consequence
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Copeland
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Dat'r
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Deer Tick
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Deerhoof
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Dirty on Purpose
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Dntel
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Emily Haines & the Soft Skeleton
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Fall Out Boy
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Feist
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Forgive Durden
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Grinderman
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Harley Poe
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Isobel Campbell
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Ladyhawk
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Loch Lomond
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Love Arcade
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Menomena
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Modest Mouse
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Mohair
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">My Chemical Romance
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Novi Split
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Rufus Wainwright
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Scissor Sisters
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Scott Walker
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Sean Lennon
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Sonic Youth
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Spoon
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">St. Vincent
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Straylight Run
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Supreeme
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Tech N9ne
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Tegan and Sara
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Decemberists
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Good The Bad and The Queen
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Killing Moon
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Polyphonic Spree
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Rosebuds
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Shins
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">The Used
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Under the Influence of Giants
"; } ?> " 8) { ?>style="font-weight:bold; color:#FFFFFF;">Unkle
0) { ?>
Prior to attending this show I didn't quite grasp the concepts implied by "Broken Social Scene Presents: Kevin Drew." I was curiously skeptical as to why Broken Social Scene would be presenting their own front man as if he were...
0) { ?>
Yesterday was the opener for the 10,000 Lakes Festival at the Soo Pass Ranch in Detroit Lakes, MN. It was hot and muggy, but the sticky summer weather didn’t put a damper on festival spirits. The campground population was growing...
0) { ?>
FESTIVAL. DAY 1. SATURDAY. 5.26. It’s 7p.m. and I’m still a bit hung-over from my prior night/morning in Chicago. I am definitely lacking sleep and despite my cute outfit I am well aware I look haggard. Not the easiest way to begin a three day extravaganza of techno, dancing, and drugs. But to hell with it; this is Detroit!
0) { ?>
Last week I had to drive to Cincinnati and catch Artimus Pyledriver and Fu Manchu who were playing at this place called the Madhatter's in Covington, KY, across the river from Cincinnati. A real shithole. But then again, they got...
0) { ?>
“Bombs” were dropped on Indianapolis on Wednesday, February 21st — bombs that got the party hyped and the dance floor moving.
0) { ?>
The term "retro" is applicable to many bands in the indie rock genre. While most of these bands incorporate elements similar to popular music from the past 30 years, The Decemberists, from Portland, Ore., create sounds that echo a time when baroque and folk ruled the musical landscape of the Western world.
0) { ?>
The Reverend Peyton's Big Damn Band brings something special to today's music world, through a genre that first thrived short of a century ago: Root Blues.
0) { ?>
Gregg Gillis, aka Girl Talk, is making his own unique mark in the music world. When he's not biomedically engineering things, he's dancing around and taking his clothes off while mashing up some crunk beats on his laptop at clubs....
0) { ?>
After my recent review of The Format's new album, I had a chance to do a phone interview with the band.
0) { ?>
In a roundtable interview at Warped Tour 2006 in Indianapolis, Motion City Soundtrack tells us about their inspirations and future.