HOME NEWS REVIEWS ARTICLES MUSICIANS GUIDES PHOTOS FORUMS MOBILE RADIO
Welcome Site Map Shows Daily MP3s Videos Podcast Upcoming Releases Editorial Calendar Contests  
Advanced
Contact Us   |   Advertise   |   For Contributors   |   For Musicians
<%init> my @Months = ('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'); my @tmp_time = localtime(time()); my $curmonth = $Months[$tmp_time[4]]; my $curyear = $tmp_time[5] + 1900; my $dbh = DBI->connect("DBI:mysql:allaboutjazz", 'vxweb', 'vx232web'); my ($month, $album, $artist, $origfile); my $query_sql = qq { SELECT album, artist, month, origfile FROM cd_review WHERE (genre = ? or genre_id = ?) and year = ? ORDER BY month DESC, album }; my $sth = $dbh->prepare($query_sql); $sth->execute('Electronica', 7, $tmp_time[5] - 100); <%cleanup> $dbh->disconnect();





You've Got a Friend
Kevin Hays Trio
Gettin' Blazed
Jermaine Landsberger
Mystique
Amaryllis Santiago
Euphrates, Me Jane
Bipolar
Plays Tribute to Oscar Peterson
Resonance Big Band
I'm in Heaven Tonight
Sarah DeLeo
Advertise Here



.
Electronica CD reviews: <% $curyear %>
<& /electronica/electronica_review_archive.tmp &>
% my $tmp_month = 00; % while ( ($album, $artist, $month, $origfile) = $sth->fetchrow_array() ) % { % if ($tmp_month != $month) % { % $tmp_month = $month;

<% $Months[$month-1] %>

% } <% $album %> by <% $artist %>
% } Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band, Big Band


  Privacy Policy | Dedicated Servers All material copyright © 2009 All About Jazz and/or contributing writers/visual artists. All rights reserved.