Books

Search all Books:
".str_replace('','’',$row_book['inventory_title']).""; // authors // mysql_select_db($database_econtent, $econtent); $query_article_author = "SELECT * FROM inventory_author WHERE inventory_id = '".$_GET['book']."' AND author_id IS NOT NULL ORDER BY author_order"; $article_author = mysql_query($query_article_author, $econtent) or die(mysql_error()); $row_article_author = mysql_fetch_assoc($article_author); $totalRows_article_author = mysql_num_rows($article_author); if ($totalRows_article_author >= 1){ $i = 0; echo "

By "; do { mysql_select_db($database_econtent, $econtent); $query_author = "SELECT * FROM author WHERE author_id = '".$row_article_author['author_id']."'"; $author = mysql_query($query_author, $econtent) or die(mysql_error()); $row_author = mysql_fetch_assoc($author); $totalRows_author = mysql_num_rows($author); $i++; if ($i > 1){ echo ", "; } echo $row_author['author_firstname']." ".$row_author['author_lastname']; } while ($row_article_author = mysql_fetch_assoc($article_author)); echo "

"; } ?>
"; // overview // if (!is_null($row_book['inventory_description'])){ echo "
"; echo "

Overview

"; echo $row_book['inventory_description']; echo "
"; } // toc // if (!is_null($row_book['inventory_toc'])){ echo "
"; echo "

Table of Contents

"; echo $row_book['inventory_toc']; echo "
"; } // reviews // if (!is_null($row_book['inventory_review'])){ echo "
"; echo "

Reviews

"; echo "

".$row_book['inventory_review']."

"; echo "
"; } echo "
"; echo "
"; if (!is_null($row_book['inventory_image'])){ echo "

".$row_book[

"; } else { echo "

".$row_book[

"; } // cart link // /* if ($row_book['inventory_available'] == 'y'){ echo "
"; echo "
"; echo ""; echo "

Institution: \$".$row_book['inventory_price_inst']."
"; echo "Individual: \$".$row_book['inventory_price_ind']."
"; echo "Student: \$".$row_book['inventory_price_stud']."

"; echo ""; echo ""; echo ""; echo "
"; echo "
"; } */ echo "

"; echo "Published: ".date('Y',strtotime($row_book['inventory_date']))."
"; if (!is_null($row_book['inventory_isbn'])){ echo "ISBN:
".$row_book['inventory_isbn']."
"; } if (!is_null($row_book['inventory_pages'])){ echo "Pages: ".$row_book['inventory_pages']."
"; } if (!is_null($row_book['inventory_imprint'])){ echo "Imprint:
".$row_book['inventory_imprint']."
"; } /* if (!is_null($row_book['inventory_url'])){ echo "Visit Website
"; } */ echo "

"; if (!is_null($row_book['inventory_ebooks'])){ echo "

This book is available as a pdf from eBooks.

"; } ?>
"; } else { echo "

Requested book currently not available.

"; } ?>
My Home The Block

"; } // ========== x-promote ==============// mysql_select_db($database_econtent, $econtent); $query_inv = "SELECT * FROM inventory WHERE inventory_id = '".$_GET['book']."'"; $inv = mysql_query($query_inv, $econtent) or die(mysql_error()); $row_inv = mysql_fetch_assoc($inv); $totalRows_inv = mysql_num_rows($inv); if (!is_null($row_inv['xprom1'])){ mysql_select_db($database_econtent, $econtent); $query_xprom = "SELECT * FROM inventory WHERE inventory_id = '".$row_inv['xprom1']."'"; $xprom = mysql_query($query_xprom, $econtent) or die(mysql_error()); $row_xprom = mysql_fetch_assoc($xprom); $totalRows_xprom = mysql_num_rows($xprom); if ($row_xprom['inventory_type']=="Special Issue"){ mysql_select_db($database_econtent, $econtent); $query_jrnltitle = "SELECT journal_title, journal_url FROM journal WHERE journal_acronym = '".$row_xprom['inventory_journal']."'"; $jrnltitle = mysql_query($query_jrnltitle, $econtent) or die(mysql_error()); $row_jrnltitle = mysql_fetch_assoc($jrnltitle); $totalRows_jrnltitle = mysql_num_rows($jrnltitle); echo "

Related special issue from ".$row_jrnltitle['journal_title']."

"; echo "

"; if (!is_null($row_xprom['inventory_url'])){ echo "“".$row_xprom['inventory_title']."”"; } echo "
".substr(strip_tags($row_xprom['inventory_description']),0,300)."..."; if (!is_null($row_xprom['inventory_url'])){ echo "Visit Website"; } echo "

"; } elseif ($row_xprom['inventory_type']=="Book"){ echo "

Related title from eContent Management

"; echo "

"; echo "“".$row_xprom['inventory_title']."”"; echo "
".substr(strip_tags($row_xprom['inventory_description']),0,300)."..."; echo "More ...

"; } } echo "
"; if (!is_null($row_inv['xprom2'])){ mysql_select_db($database_econtent, $econtent); $query_xprom = "SELECT * FROM inventory WHERE inventory_id = '".$row_inv['xprom2']."'"; $xprom = mysql_query($query_xprom, $econtent) or die(mysql_error()); $row_xprom = mysql_fetch_assoc($xprom); $totalRows_xprom = mysql_num_rows($xprom); if ($row_xprom['inventory_type']=="Special Issue"){ mysql_select_db($database_econtent, $econtent); $query_jrnltitle = "SELECT journal_title, journal_url FROM journal WHERE journal_acronym = '".$row_xprom['inventory_journal']."'"; $jrnltitle = mysql_query($query_jrnltitle, $econtent) or die(mysql_error()); $row_jrnltitle = mysql_fetch_assoc($jrnltitle); $totalRows_jrnltitle = mysql_num_rows($jrnltitle); echo "

Related special issue from ".$row_jrnltitle['journal_title']."

"; echo "

"; if (!is_null($row_xprom['inventory_url'])){ echo "“".$row_xprom['inventory_title']."”"; } echo "
".substr(strip_tags($row_xprom['inventory_description']),0,300)."..."; if (!is_null($row_xprom['inventory_url'])){ echo "Visit Website"; } echo "

"; } elseif ($row_xprom['inventory_type']=="Book"){ echo "

Related title from eContent Management

"; echo "

"; echo "“".$row_xprom['inventory_title']."”"; echo "
".substr(strip_tags($row_xprom['inventory_description']),0,300)."..."; echo "More ...

"; } } // ========== x-promote ==============// // all books, none selected // } else { ?>
Browse by Category:
0){ do { echo "
"; if (!is_null($row_booklist['inventory_image'])){ echo "

".htmlspecialchars($row_booklist[

"; } else { echo "

".htmlspecialchars($row_book[

"; } echo "

".htmlentities($row_booklist['inventory_title']).""; echo ""; mysql_select_db($database_econtent, $econtent); $query_book_author = "SELECT author_id FROM inventory_author WHERE inventory_id = '".$row_booklist['inventory_id']."' ORDER BY author_order"; $book_author = mysql_query($query_book_author, $econtent) or die(mysql_error()); $row_book_author = mysql_fetch_assoc($book_author); $totalRows_book_author = mysql_num_rows($book_author); $i = 0; if ($totalRows_book_author>0){ echo "
"; do { mysql_select_db($database_econtent, $econtent); $query_author = "SELECT * FROM author WHERE author_id = '".$row_book_author['author_id']."'"; $author = mysql_query($query_author, $econtent) or die(mysql_error()); $row_author = mysql_fetch_assoc($author); $totalRows_author = mysql_num_rows($author); $i++; if ($i > 1){ echo ", "; } echo $row_author['author_firstname']." ".$row_author['author_lastname']; } while ($row_book_author = mysql_fetch_assoc($book_author)); echo "
"; } if (!empty($row_booklist['inventory_isbn'])){ echo "
ISBN: ".$row_booklist['inventory_isbn']."

"; } echo "
"; } while ($row_booklist = mysql_fetch_assoc($booklist)); } else { echo "

No Books in this category.

"; } } ?>