NEW RELEASES
Pete Heller
Dirty Grooves- Nite:Life 014
(NRK)
Rithma
Music Fiction
(Om Records)
DJ Sage
Drum & Bass Elements 01
(Moonshine)
Darren Emerson & Mutiny
Underwater Episode vol.2
(Underwater Records)
Jamez
Dreamchasing
(Future Groove)
Dave Ralph
Resident Alien
(System Recordings)
Jaga Jazzist
Stix
(Ninja Tune)
|
.
|
<%doc>
## DAILY.HTML ## 04-13-2002 ##
days_past - Number of days to go back
review_limit - Amount of reviews to display for each past day (see days_past above)
- Review limit of -1 means to grab them all.
Simply set the variables below to new defaults or reference them in a URL like:
http://www.allaboutjazz.com/dir/daily.html?days_past=2&review_limit=20
<%args>
$days_past => 10
$review_limit => -1
$genre => ""
<%init>
my $dbh = DBI->connect("DBI:mysql:aadj", 'vxweb', 'vx232web');
my ($id, $album, $artist, $origfile, $pubdays, $pretty);
my ($genre_id, $genre_name) = split (/\|/, $genre);
my $sql = "SELECT DISTINCT id, artist, album, origfile, TO_DAYS(date_published) As DateDays, \n";
$sql .= "DATE_FORMAT(date_published, '%M %e, %Y') As PrettyDate \n";
$sql .= "FROM cd_review \n";
$sql .= "WHERE date_published IS NOT NULL and status = 10 \n";
$sql .= "and date_published >= SUBDATE(NOW(), INTERVAL $days_past DAY) \n" if $days_past > 0;
$sql .= "and (genre = " . $dbh->quote($genre_name) . " or genre_id = $genre_id) \n" if $genre_name or $genre_id > 0;
$sql .= "ORDER BY TO_DAYS(date_published) DESC, album \n";
$sql .= "LIMIT $review_limit\n" if $review_limit > 0;
my $sql2 = "SELECT id, name from genre order by name";
<%cleanup>
$dbh->disconnect();
| Publisher's
Picks - Previous |
|
|
August
2003
Deep Dish
GU025:
Toronto
(Global Underground)
Deep Dish
Penetrate Deeper
(Yoshitoshi)
|
July
2003
Victor Calderone
Resonate
(Statra Recordings)
Doc
Martin
Fabric 10
(Fabric [Studio])
|
June
2003
|
May
2003
The Scumfrog
Extended
Engagement
(Effin Records)
Stark
Raving Mad
John Digweed & Nick Muir
(Thrive Records)
|
April
2003
Hipp-E & Halo
Fabric 07
(Fabric [Studio])
Stereo
Sushi 4
Various artists
(Stereo Sushi Records)
|
March
2003
|
February
2003
Massive Attack
100th Window
(Virgin Records)
Tosca
Dehli
9
(G Stone Recordings)
|
January
2003
|
|
|
<& /adsystem/rotate.tmp &>
|
|
