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







Let's Play
Project Grand Slam
Infinita
Lawson Rollins
The Jazz Session
Denise Brigham
Simply Sacha
Sacha Boutros
Storyteller
Rob Mullins
Conversations with My Family
Mike Garson
Cover Up!
George Kahn
Advertise Here



Push AAJ Content
AAJ Live | RSS | Widsets




.
Funk/Groove Jazz CD reviews: <% $curyear %>
<& /acid/funk_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.