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('Fusion', 10, $tmp_time[5] - 100); <%cleanup> $dbh->disconnect();












Fusion/Prog Rock CD reviews: <% $curyear %>
<& /fusion/fusion_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