STORES: CDs/DVDs/Vinyl/Sleeves | Downloads | Posters | Art
HOME NEWS REVIEWS ARTICLES MUSICIANS PHOTOS FORUMS
Login   |   MY AAJ Signup  
Intro Site Map Shows Free Daily MP3s Videos Upcoming Releases Guides Editorial Calendar Contests Help Wanted  
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('Fringes of Jazz', 8, $tmp_time[5] - 100); <%cleanup> $dbh->disconnect();





Tough Guys
The Generations Band
Summer Samba
Irene and Her Latin Jazz Band
Raindrops
Duane Andrews
Into The World; A Musical Offering
Andrea Brachfeld
Cover Up!
George Kahn
Lifelines
Bruno Raberg with Chris Cheek and Ben Monder
Home
Oscar Utterstrom Quintet
Advertise Here


Push AAJ Content
AAJ Live | RSS | Widsets


.
Fringes of Jazz CD reviews: <% $curyear %>
<& /fringes/fringes_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 © 2008 All About Jazz and/or contributing writers/visual artists. All rights reserved.