I'm primarily a Science Fiction collector, but I also collect:
- Books by/about James Boswell
- Thorne Smith
This is not an exhaustive list. It just contains those wants that I have entered into my database. Feel free to quote any SF first editions.
Condition: I'm really only interested in F/F copies, unless the book is very scarce.
Thanks!
-John
Contact Information
Email (preferred): john@bozweb.com
John Boswell
Right. I'm testing a new interface. Titles below link directly to Amazon. :)
getMessage () . "\n");
?>
Current WantList
query ("SELECT isbn, title,updated FROM books_read WHERE current = 'y' order by updated desc");
// date query:
//$qry = "select isbn, dateRead from books where STR_TO_DATE(dateRead, '%m-%d-%Y') >STR_TO_DATE('12-12-2004', '%m-%d-%Y') and dateRead is not null and dateRead != '' order by STR_TO_DATE(dateRead, '%m-%d-%Y')";
//$myresult =& $connection->query ("SELECT isbn, dateAdded,title FROM books WHERE owned != 'true' order by dateAdded desc,title");
//$qry = "SELECT isbn, dateModified,title FROM books WHERE owned != 'true' or owned is null order by STR_TO_DATE(dateModified, '%m-%d-%Y') desc,title ";
/* order by title: */
$qry = "SELECT isbn, dateModified,title FROM books WHERE owned != 'true' or owned is null order by title ";
$myresult =& $connection->query ($qry);
$count = 0;
//while ($obj =& $myresult->fetchRow (DB_FETCHMODE_OBJECT)) {
while ($row =& $myresult->fetchRow ()) {
//$products = $amazon->searchAsin($obj->isbn);
$products = $amazon->searchAsin($row[0]);
if(!PEAR::isError($products)) {
foreach($products as $product)
{
if ( strlen($product['name']) > 0 )
{
$creator = 'by ' . implode(', ', $product['authors']);
if (($count % 3) == 0 && $count > 0 ) {
echo("\n
\n\n"); // end a row and start new one
}
$count++;
?>
|
URL: http://www.bozweb.com/wantlist.html