'categories', )); $categoriesRecord = @$categoriesRecords[0]; // get first record $title = ""; foreach ($categoriesRecords as $category) { if($category['num'] == @$_REQUEST['main_category']) { $title = $category['title']; } } // show error message if no matching record is found if (!$categoriesRecord) { header("HTTP/1.0 404 Not Found"); print "Record not found!"; exit; } list($product_subcategoriesRecords, $product_subcategoriesMetaData) = getRecords(array( 'tableName' => 'product_subcategories', 'orderBy' => 'title', )); /* CLAIRE ADDED CODE HERE */ $products_query = array('tableName' => 'product_details'); if(isset($_REQUEST['avail']) { if($_REQUEST['avail'] == 'true') { $products_query['where'] = 'availability = "In Stock Now"'; } else if($_REQUEST['avail'] == 'false') { $products_query['where'] = 'availability = "Unavailable"'; } } list($product_detailsRecords, $product_detailsMetaData) = getRecords($products_query); /* END ADDED CODE */ list($slideshowRecords, $slideshowMetaData) = getRecords(array( 'tableName' => 'slideshow', 'limit' => '1', )); $slideshowRecord = @$slideshowRecords[0]; // get first record // show error message if no matching record is found if (!$slideshowRecord) { header("HTTP/1.0 404 Not Found"); print "Record not found!"; exit; } ?> <?php echo $title; ?>
'slideshow', 'limit' => 1, 'allowSearch' => false, )); $images = array(); if ($randomImageRecord) { $images = $randomImageRecord[0]['images']; } ?>

   

« Previous page

All Products | In Stock | Unavailable
 

'product_details', 'allowSearch' => false, 'where' => "subcategory = '". intval($record['num'])."'", )); ?>

No records were found! Please choose a different category.