$upload): ?>
| SEARCH BOOKS |
|
| Use any of the pull down fields below to narrow your search. Use only those criteria most important to you. You can always change your search criteria and re-submit. Hint: to select more than one option for any of the fields below, hold the CTRL (CMD) key and click to highlight each of the options. |
|
| Book Search 1: "; // set default value // cycle through each genre selected foreach ($_REQUEST['genre, genre_2, genre_3_match[]'] as $genre_3) { // lookup genre number in database $genreRecord = mysql_get("genre_categories", $genre_3); if ($genreRecord) { // add "genre" value to output @$booksearchCriteria .= $genreRecord['genre_names'] .", "; } } } // End Book Type Search // Start Genre 1 @$genresearchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['genre_match']) { @$genresearchCriteria = "Genre 1: "; // set default value // cycle through each genre selected foreach ($_REQUEST['genre_match'] as $genre) { // lookup genre number in database $genreRecord = mysql_get("genre_categories", $genre); if ($genreRecord) { // add "genre" value to output @$genresearchCriteria .= $genreRecord['genre_names'] .", "; } } } // End Genre 1 // Start Genre 2 @$genre_2searchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['genre_2_match']) { @$genre_2searchCriteria = "Genre 2: "; // set default value // cycle through each genre 2 selected foreach ($_REQUEST['genre_2_match'] as $genre_2) { // lookup Genre 2 number in database $genre_2Record = mysql_get("genre_categories", $genre_2); if ($genre_2Record) { // add "genre 2" value to output @$genre_2searchCriteria .= $genre_2Record['genre_names'] .", "; } } } // End Genre 2 // Start Genre 3 @$genre_3searchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['genre_3_match']) { @$genre_3searchCriteria = "Genre 3: "; // set default value // cycle through each genre 3 selected foreach ($_REQUEST['genre_3_match'] as $genre_3) { // lookup Genre 2 number in database $genre_3Record = mysql_get("genre_categories", $genre_3); if ($genre_3Record) { // add "genre 3" value to output @$genre_3searchCriteria .= $genre_3Record['genre_names'] .", "; } } } // End Genre 3 // Start Book Location @$locationsearchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['location_match']) { @$locationsearchCriteria = "Location: "; // set default value // cycle through each location selected foreach ($_REQUEST['location_match'] as $location) { // lookup location number in database $locationRecord = mysql_get("book_location", $location); if ($locationRecord) { // add "location" value to output @$locationsearchCriteria .= $locationRecord['shelf_location'] .", "; } } } // End Book Location // Start Quality @$qualitysearchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['quality_match']) { @$qualitysearchCriteria = "Quality: "; // set default value // cycle through each quality selected foreach ($_REQUEST['quality_match'] as $quality_values) { // lookup quality number in database $qualityRecord = mysql_get("quality_categories", $quality_values); if ($qualityRecord) { // add "quality" value to output @$qualitysearchCriteria .= $qualityRecord['quality_values'] .", "; } } } // End Quality //******************************************** // Start Paper Engineer Rating @$paper_engineer_ratingsearchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['paper_engineer_rating_keyword']) { @$paper_engineer_ratingsearchCriteria = "Paper Engineer Rating: "; // set default value // cycle through each Paper Engineer Rating selected foreach ($_REQUEST['paper_engineer_rating_keyword'] as $paper_engineer_rating_values) { // lookup Paper Engineer Rating number in database $paper_engineer_ratingRecord = mysql_get("paper_engineer_rating_categories", $paper_engineer_rating_values); if ($paper_engineer_ratingRecord) { // add "Paper Engineer Rating" value to output @$paper_engineer_ratingsearchCriteria .= $paper_engineer_ratingRecord['paper_engineer_rating_values'] .", "; } } } // End Paper Engineer Rating // Start Overall Rating @$overall_ratingsearchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['overall_rating_keyword']) { @$overall_ratingsearchCriteria = "Overall Rating: "; // set default value // cycle through each Overall rating selected foreach ($_REQUEST['overall_rating_keyword'] as $overall_rating_values) { // lookup Overall Rating number in database $overall_ratingRecord = mysql_get("overall_rating_categories", $overall_rating_values); if ($overall_ratingRecord) { // add "Overall Rating" value to output @$overall_ratingsearchCriteria .= $overall_ratingRecord['overall_rating_values'] .", "; } } } // End Overall Rating // Start Illustration Rating @$illustration_ratingsearchCriteria = ""; // set default value if ((@$_REQUEST['save'] == 1) && @$_REQUEST['illustration_rating_keyword']) { @$illustration_ratingsearchCriteria = "Illustration_Rating: "; // set default value // cycle through each Illustration Rating selected foreach ($_REQUEST['illustration_rating_keyword'] as $illustration_rating_values) { // lookup Illustration Rating number in database $illustration_ratingRecord = mysql_get("illustration_rating_categories", $illustration_rating_values); if ($illustration_ratingRecord) { // add "Illustration Rating" value to output @$illustration_ratingsearchCriteria .= $illustration_ratingRecord['illustration_rating_values'] .", "; } } } // End Illustration Rating //*************************************************** if ((@$_REQUEST['save'] == 1) && @$_REQUEST['get_better_copy'] && @$_REQUEST['get_better_copy'] == 1) { @$bettercopysearchCriteria .= "Look For A Better Copy: Yes"; } if ((@$_REQUEST['save'] == 1) && @$_REQUEST['want_this_book'] && @$_REQUEST['want_this_book'] == 1) { @$wantbooksearchCriteria .= "Want This Book: Yes"; } // if ((@$_REQUEST['save'] == 1) && @$_REQUEST['get_better_copy'] && (@$_REQUEST['get_better_copy'] == 0 || @$_REQUEST['get_better_copy'] == "")) { @$bettercopysearchCriteria .= "Look For A Better Copy: No"; } @$locationsearchCriteria = chop(@$locationsearchCriteria, ', '); // remove trailing , or spaces @$locationsearchCriteria = chop(@$locationsearchCriteria, '- '); // remove trailing - or spaces @$genresearchCriteria = chop(@$genresearchCriteria, ', '); // remove trailing , or spaces @$genresearchCriteria = chop(@$genresearchCriteria, '- '); // remove trailing - or spaces @$qualitysearchCriteria = chop(@$qualitysearchCriteria, ', '); // remove trailing , or spaces @$qualitysearchCriteria = chop(@$qualitysearchCriteria, '- '); // remove trailing - or spaces //*************************************** @$paper_engineer_ratingsearchCriteria = chop(@$paper_engineer_ratingsearchCriteria, ', '); // remove trailing , or spaces @$paper_engineer_ratingsearchCriteria = chop(@$paper_engineer_ratingsearchCriteria, '- '); // remove trailing - or spaces @$overall_ratingsearchCriteria = chop(@$overall_ratingsearchCriteria, ', '); // remove trailing , or spaces @$overall_ratingsearchCriteria = chop(@$overall_ratingsearchCriteria, '- '); // remove trailing - or spaces @$illustration_ratingsearchCriteria = chop(@$illustration_ratingsearchCriteria, ', '); // remove trailing , or spaces @$illustration_ratingsearchCriteria = chop(@$illustration_ratingsearchCriteria, '- '); // remove trailing - or spaces //************************************** @$bettercopysearchCriteria = chop(@$bettercopysearchCriteria, ', '); // remove trailing , or spaces @$bettercopysearchCriteria = chop(@$bettercopysearchCriteria, '- '); // remove trailing - or spaces @$wantbooksearchCriteria = chop(@$wantbooksearchCriteria, ', '); // remove trailing , or spaces @$wantbooksearchCriteria = chop(@$wantbooksearchCriteria, '- '); // remove trailing - or spaces @$booksearchCriteria = chop(@$booksearchCriteria, ', '); // remove trailing , or spaces @$booksearchCriteria = chop(@$booksearchCriteria, '- '); // remove trailing - or spaces ?> | |
= 2):?> There are There is = 2):?> listings listing that = 2):?> match matches all listings Title including: {$_REQUEST['title_query']}"; } ?> Book Search including: {@$booksearchCriteria}"; } ?> Writer's Name including: {$_REQUEST['writer_1,writer_2_query']}"; } ?> Illustrator's Name including: {$_REQUEST['illustrator_1,illustrator_2_query']}"; } ?> Paper Engineer's Name including: {$_REQUEST['paper_engineer_1,paper_engineer_2,paper_engineer_3_query']}"; } ?> Publisher's Name including: {$_REQUEST['publisher_query']}"; } ?> Publication Date including: {$_REQUEST['publication_date_query']}"; } ?> Papaer Engineer Rating of: {$_REQUEST['paper_engineer_rating_query']}"; } ?> Overall Rating of: {$_REQUEST['overall_rating_query']}"; } ?> Illustration Rating of: {$_REQUEST['illustration_rating_query']}"; } ?> Purchased From including: {$_REQUEST['purchased_from_query']}"; } ?> Purchase Date including: {$_REQUEST['purchase_date_query']}"; } ?> Purchase Price including: {$_REQUEST['purchase_price']}"; } ?> Sold To including: {$_REQUEST['sold_to']}"; } ?> Sales Date including: {$_REQUEST['sale_date']}"; } ?> Sales Price including: {$_REQUEST['sale_price']}"; } ?> |
|
Modify This Entry There are more images for this book. Click/tap the cover image to see them. $upload): ?> Want This Book: Title: Book Location: Publisher: Publication Date: Purchased On: from: for: Book Quality: Look For Better Copy: Paper Engineer Rating: Overall Rating: Illustration Rating: Want This Book: And Sold On: to: for: Genre 1: Genre 2: Genre 3: Comments: Special Information: ISBN: Writer(s): , Illustrator(s): , Paper Engineer(s): , , YouTube Links Modify This Entry There are more images for this book. Click/tap the cover image to see them. $upload): ?> Want This Book: Title: Book Location: Publisher: Publication Date: Purchased On: from: for: Book Quality: Paper Engineer Rating: Overall Rating: Illustration Rating: Look For Better Copy: Want This Book: And Sold On: to: for: Genre 1: Genre 2: Genre 3: Comments: Special Information: ISBN: Writer(s): , Illustrator(s): , Paper Engineer(s): , , YouTube Links |