Search Field Issue
11 posts by 3 authors in: Forums > CMS Builder
Last Post: July 14, 2011 (RSS)
By Jason - July 14, 2011
Hi,
If you want to do the searches manually, you can try this:
Hope this helps
If you want to do the searches manually, you can try this:
// remove white space
if (@$_REQUEST['name_keyword']) {
$_REQUEST['name,search_words_keyword'] = str_replace(" ", "", $_REQUEST['name,search_words_keyword']);
}
list($itemsRecords, $itemsMetaData) = getRecords(array(
'tableName' => 'items',
'where' => "REPLACE(name, ' ', '') LIKE '%".mysql_escape(@$_REQUEST['name,search_words_keyword'])."%'
OR REPLACE(search_words, ' ', '') LIKE '%".mysql_escape(@$_REQUEST['name,search_words_keyword'])."%'",
'allowSearch' => false,
'limit' => '45',
));Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/