<& /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

2012 Covers Winners


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



% if ($#books >= 0){ % for ($i = 0; $i <= $#books; $i++){
<%$books[$i][0]%>
% $j ++; % if ($j > 3){
% $j = 1; % } % } % }
<& /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 $j = 1; my @temp; my @books; $sql = "SELECT title, author, publisher, designfirm, artdirector, designer, othercredits, book, cover, coverimage, nominator, id, finalist_cover, book FROM 5050_2012 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 }