<& /designobservercomp/header.comp, site=>1, adcols=>2 &> <& /designobservercomp/nav_designobserver.comp &>
50 Books/50 Covers

<& /designobserver/50Books50Covers/5050-2011-nav.comp &>
Information & Guidelines Judges & Advisors Nominate a Book Nominations Winners

2011 Covers Winners


SORT: 2012 BOOKS | 2012 COVERS | 2011 BOOKS | 2011 COVERS



% if ($#books >= 0){ % for ($i = 0; $i <= $#books; $i++){
<%$books[$i][0]%>
<%$books[$i][0]%>
<%$books[$i][1]%>
<%$books[$i][2]%>

Nominator: <%$books[$i][10]%>

% if ($books[$i][5]){ Designer: <%$books[$i][5]%>
% } % if ($books[$i][4]){ Art Director: <%$books[$i][4]%>
% } % if ($books[$i][3]){ Design Firm: <%$books[$i][3]%>
% } % if ($books[$i][6]){ Other Credits: <%$books[$i][6]%>
% }

% } % }
<& /designobservercomp/adDOG_2col.comp &>
<& /designobservercomp/footer.comp &> <%init> use RubyCore::ObjectInit; use designobserver::Config(); my $rso = new RubyCore::ObjectInit { %designobserver::Config::c }; $rso->dbconnect(); my ($i, $sql, $sth); my @temp; my @books; $sql = "SELECT title, author, publisher, designfirm, artdirector, designer, othercredits, book, cover, coverimage, nominator, id, finalist_cover, book FROM 5050_2011 WHERE published IS NOT NULL AND cover='y' AND finalist_cover='y' ORDER BY title"; $sth = $rso->dosql($sql); while (@temp = $sth->fetchrow_array ()){ push @books, [@temp]; #add each array reference to the news array }