'items', // 'where' => "REPLACE(name, ' ', '') LIKE '%".mysql_escape(@$_REQUEST['name_keyword'])."%'", //'debugSql' => true, // 'allowSearch' => false, // 'limit' => '45', // )); list($itemsRecords, $itemsMetaData) = getRecords(array( 'tableName' => 'items', 'limit' => '500', 'where' => "hide_from_search_page != '1' ", 'ignoreHidden' => true, )); $itemsRecord = @$itemsRecords[0]; // get first record $searchSuggestions = array(); if (!$itemsRecord) { // $searchSuggestions = getSearchSuggestions('brands', 'name', @$_REQUEST['search_words_keyword'], 6); } else { // $itemsRecords = filterWithReplacementItems($itemsRecords); } list($distributionRecords, $distributionMetaData) = getRecords(array( 'tableName' => 'distribution', 'where' => whereRecordNumberInUrl(1), 'limit' => '100', )); $distributionRecord = @$distributionRecords[0]; // get first record list($brandsRecords, $brandsMetaData) = getRecords(array( 'tableName' => 'brands', 'where' => whereRecordNumberInUrl(1), 'limit' => '100', )); $brandsRecord = @$brandsRecords[0]; // get first record list($downloadsRecords, $downloadsMetaData) = getRecords(array( 'tableName' => 'downloads', 'where' => whereRecordNumberInUrl(1), 'limit' => '100', )); $downloadsRecord = @$downloadsRecords[0]; // get first record ?>
Products >> Search Results
<?php echo $record['name'] ?>

 Sorry! We were unable to locate a product that matches your search term.

Below are similar suggestions to help you refine your search.


Do you mean ?