<%doc> URL TYPE 1 - /reviews/r0201_001.htm URL TYPE 2 - /reviews/pf_r0201_001.htm URL TYPE 3 - /reviews/ft/20020321/7823/Straight_Edge_Trio.html URL TYPE 4 - /reviews/pf/20020321/7823/Straight_Edge_Trio.html <%init> my $dbh = DBI->connect("DBI:mysql:allaboutjazz", 'vxweb', 'vx232web'); <%cleanup> $dbh->disconnect(); <%perl> my @args = split('/', $r->uri); my ($title, $album, $artist, $id, $month, $year, $seq, $sql, $stmt); if ($args[2] =~ /r(\d\d)(\d\d)_(\d+)\.(htm|html)/i) { $month = $1; $year = $2; $seq = $3; $sql = "SELECT album, artist, id FROM cd_review WHERE month = ? and year = ? and seq = ?"; $stmt = $dbh->prepare($sql); $stmt->execute($month, $year, $seq); ($album, $artist, $id) = $stmt->fetchrow_array(); $stmt->finish(); } elsif ($args[2] =~ /^(pf|ft)$/i and $args[3] =~ /^(\d+)$/ and $args[4] =~ /^(\d+)$/ and $args[5] =~ /^(\w+)\.(htm|html)$/i) { $id = $2; $sql = "SELECT album, artist FROM cd_review WHERE id = ?"; $stmt = $dbh->prepare($sql); $stmt->execute($id); ($album, $artist) = $stmt->fetchrow_array(); $stmt->finish(); } if ($album and $artist) { $title = "$artist - $album"; } else { $m->comp('/title.tmp', static_title => 1); } <% $title %>
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
CD Review:



Calendar | Venues | Teachers


Child In My Heart
Tanja Maritsa
Letter to Herbie
John Beasley
Before Love Has Gone
Stevie Holland
Infinita
Lawson Rollins
Storyteller
Rob Mullins
Live in London
Gene Harris
You Decide
Rave Tesar Trio
Advertise Here




Push AAJ Content
AAJ Live | RSS | Widsets



Featured Visual Artist
Scott Friedlander



.

By


  Privacy Policy | Dedicated Servers All material copyright © 2008 All About Jazz and/or contributing writers/visual artists. All rights reserved.