'books', 'loadUploads' => true, 'allowSearch' => true, )); // load records from 'faq' list($faqRecords, $faqMetaData) = getRecords(array( 'tableName' => 'faq', 'loadUploads' => true, 'allowSearch' => false, )); // load records from 'navigation_menu' list($navigation_menuRecords, $navigation_menuMetaData) = getRecords(array( 'tableName' => 'navigation_menu', 'loadUploads' => true, 'allowSearch' => false, )); // error checking $errorsAndAlerts = ''; if (@$_REQUEST['save']) { $action = '' ; } ?> ERIC GREENBERG'S POP UP BOOKS SPREAD SHEET ">

 

$upload): ?> EG Masthead






SEARCH BOOKS - SPREAD SHEET REPORT
Select the fields that you want to show in the report.
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.


 
Title
Genre 1:
Show 'Genre 1' field?
Genre 2:
Show 'genre 2 field?
Book Location:
Show 'Location' field?
Writer(s)
Show 'Writers' field?
Illustrator(s)
Show 'Illustrators' field?
Paper Engineer(s)
Show 'Paper Engineers' field?
Publisher
Show 'Publisher' field?
Publication Date
Show 'Publication Date' field?
Quality:
Show 'Quality' field?
Get Better Copy:
Show 'Get Better Copy' field?
Purchased From
Show 'Purchased From' field?
Purchased Date
Show 'Purchase Date' field?
Purchase Price
Show 'Purchase Price' field?
Sold To
Show 'Sold To' field?
Sale Date
Show 'Sale Date' field?
Sale Price
Show 'Sale Price' field?
 
Show 'Comments' field?
Show 'ISBN'?
Show 'Special Information' field?

 

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_2Criteria = ""; // 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 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_keyword']) { @$qualitysearchCriteria = "Quality: "; // set default value // cycle through each quality selected foreach ($_REQUEST['quality_keyword'] 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 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['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 @$bettercopysearchCriteria = chop(@$bettercopysearchCriteria, ', '); // remove trailing , or spaces @$bettercopysearchCriteria = chop(@$bettercopysearchCriteria, '- '); // remove trailing - or spaces ?>
= 2):?> There are There is = 2):?> listings listing that = 2):?> match matches your search for:




All Listings Title including: {$_REQUEST['title_query']}"; } ?> 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']}"; } ?> 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']}"; } ?>

Title,
, , , , , , , , , , , , , , , , , , , , , , , , , ' , , , , , , , , , , , , , , , , , , , ,
setTimeout("location.href=\'http://www.jkwebdesigns.com/eg/downloadcsv.php\'",2*1000)'; ?>