HOME NEWS REVIEWS ARTICLES MUSICIANS SHOWS GUIDES PHOTOS FORUMS RADIO
Welcome Daily MP3s Videos Podcast Upcoming Releases Editorial Calendar Mobile Contests  
Advertise   |   Staff   |   AAJ Pro   |   Contact Us  
<%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('Blues', 4, $tmp_time[5] - 100); <%cleanup> $dbh->disconnect();





Folk Songs for Jazzers
Frank Macchia
Another Night in London
Gene Harris
Best of the Vintage
Gini Wilson
Where Is Love?
Kelley Suttenfield
Room 13
Yair Loewenson Trio
Contextualizin'
Ian Carey Quintet
Advertise Here



.
Blues CD reviews: <% $curyear %>
<& /blues/blues_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


All material copyright © All About Jazz and/or contributing writer/visual artist. All rights reserved. | Privacy Policy