Books 2007
=’2007-01-01′ AND date_read<='2007-12-31' AND meta_key='bookid' AND meta_value=perma AND post_id=ID ORDER BY Date_Read DESC"; $row = $wpdb->get_results($sql, ARRAY_A);
$yearbooks = sizeof ($row);
$yeardays = 365;
$avdays = number_format ($yeardays/$yearbooks, 2);
echo “
In 2007 I read $yearbooks books, an average of one every $avdays days.
“;
echo “
- “;
- “;
echo “$c. $book[Title] by $book[First] $book[Last] ($dread)”;
echo “
$c = $yearbooks;
foreach ($row as $book)
{
$dread =strtolower (date (“j/m/Y”,strtotime(rawurldecode($book[Date_Read]))));
$st = strtotime ($book[post_date]);
$sy = date (“Y”, $st);
$sm = date (“m”, $st);
$sd = date (“d”, $st);
$slug = “/$sy/$sm/$sd/$book[post_name]/”;
// $link = “http://www.amazon.co.uk/exec/obidos/ASIN/”.$book[uk_asin].”/nocto-21″;
// $slink = //”http://www.amazon.co.uk/exec/obidos/external-search?tag=nocto-21&keyword=”.$book[First].”%20″.$book[Last].”&mode=books”;
echo “
“;
$c–;
}
?>
Join the discussion
One reply to “Books 2007”
[…] I read 77 books in 2007, which was plenty and more than I’d expected to get through. Only 7 books were non fiction, but that’s about the ratio I like, and I read ten out of the thirteen books on the Booker Prize longlist which I really enjoyed doing. […]