Book Reviews

".$row_review['review_title'].""; if (!is_null($row_review['review_author'])){ echo "

By ".$row_review['review_author']."

"; } echo "

"; if (!is_null($row_review['review_isbn'])){ echo "ISBN: ".$row_review['review_isbn']."; "; } if (!is_null($row_review['review_date'])){ echo " ".$row_review['review_date']."; "; } if (!is_null($row_review['review_pages'])){ echo " ".$row_review['review_pages']." pages; "; } if (!is_null($row_review['review_publisher'])){ echo " ".$row_review['review_publisher']."; "; } echo "

"; // reviewers // mysql_select_db($database_econtent, $econtent); $query_article_author = "SELECT * FROM review_author WHERE review_id = '".$row_review['review_id']."'"; $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); 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); echo "

Reviewed by ".$row_author['author_firstname']." ".$row_author['author_lastname']."
"; echo $row_author['author_affiliation']."

"; } while ($row_article_author = mysql_fetch_assoc($article_author)); echo "
"; if (!is_null($row_review['review_buy'])){ ?>

Toggle references

References

"; echo ""; } else { ######################################## book reviews ################################### if (isset($_GET['view']) && $_GET['view'] != 'all'){ $view=" AND review_journal = '".$_GET['view']."'"; } else { $view = ""; } mysql_select_db($database_econtent, $econtent); $query_review = "SELECT * FROM reviews WHERE review_mm = 'n'".$view.""; $review = mysql_query($query_review, $econtent) or die(mysql_error()); $row_review = mysql_fetch_assoc($review); $totalRows_review = mysql_num_rows($review); $num_rows=$totalRows_review; $a =& new Paginator_html($_GET['page'],$num_rows); $a->set_Limit(12); $a->set_Links(3); $limit1 = $a->getRange1(); $limit2 = $a->getRange2(); $sort = "review_title ASC"; mysql_select_db($database_econtent, $econtent); $query_review = "SELECT * FROM reviews WHERE review_mm = 'n'".$view." ORDER BY ".$sort." LIMIT ".$limit1.", ".$limit2; $review = mysql_query($query_review, $econtent) or die(mysql_error()); $row_review = mysql_fetch_assoc($review); $totalRows_review = mysql_num_rows($review); if ($totalRows_review > 0){ do { echo "
"; echo "
"; if (!is_null($row_review['review_buy'])){ ?> "; } echo "
"; echo "

"; echo "".htmlentities($row_review['review_title']).""; if (!is_null($row_review['review_author'])){ echo "
".$row_review['review_author'].""; } echo "

"; if (!is_null($row_review['review_text'])){ echo "

".sub_string(strip_tags($row_review['review_text']),250); echo " ... read more »

"; } echo "

Reviewed by "; // authors // mysql_select_db($database_econtent, $econtent); $query_article_author = "SELECT * FROM review_author WHERE review_id = '".$row_review['review_id']."'"; $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); $i = 0; 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 "

"; echo "
"; } while ($row_review = mysql_fetch_assoc($review)); $a->previousNext(); } } echo "
"; include ($_SERVER['DOCUMENT_ROOT']."/inc/right.inc.php"); include ($_SERVER['DOCUMENT_ROOT']."/inc/left.inc.php"); include ($_SERVER['DOCUMENT_ROOT']."/inc/foot.inc.php"); ?>