Vyhľadávanie s medzerami

$criteria = array();
if (isset($search_text) && gen_not_null($search_text)) {
  $search_fields = array('sku', 'description_short');
  $criteria[] = '(' . implode(' like \'%' . $search_text . '%\' or ', $search_fields) . ' like \'%' . $search_text . '%\')';
}
// build search filter string
$search = (sizeof($criteria) > 0) ? (' where ' . implode(' and ', $criteria)) : '';

$field_list = array('id', 'sku', 'quantity_on_hand', 'description_short', 'full_price');

$query_raw = "select " . implode(', ', $field_list)  . " from " . TABLE_INVENTORY . $search . "";

$query_split  = new splitPageResults($_GET['list'], MAX_DISPLAY_SEARCH_RESULTS, $query_raw, $query_numrows);
$query_result = $db->Execute($query_raw);

preg_replace("'\s+'", "'+'", $search_text);