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('Modern Jazz/Free Improvisation', 14, $tmp_time[5] - 100); <%cleanup> $dbh->disconnect();





Freefall
The Chuck Anderson Trio
Another Night in London
Gene Harris
Room 13
Yair Loewenson Trio
Where Is Love?
Kelley Suttenfield
Here In the Moment
Gail Pettis
Simpatico
Claudio Roditi
Advertise Here



.
Modern Jazz/Free Improvisation CD reviews: <% $curyear %>
<& /modern/modern_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 | AAJ Supports: Lens Lady All material copyright © 2009 All About Jazz and/or contributing writer/visual artist. All rights reserved.