From 5895162b21c18b47ffff966184e8f2917095e6dd Mon Sep 17 00:00:00 2001 From: Thomas Mudrunka Date: Fri, 19 Aug 2011 00:24:01 +0200 Subject: [PATCH] Fixnuty vyhledavani - konflikt v nazvech promennych a chybejici zavorky v query... --- index.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/index.php b/index.php index ce099b1..9900ba7 100755 --- a/index.php +++ b/index.php @@ -342,13 +342,13 @@ class Sklad_DB extends PDO { if($search) { $search = $this->quote($search); if(!isset($search_fields[$class])) $this->post_redirect_get($class, "Ve tride $class zatim vyhledavat nemozno :-("); - $search = ''; - foreach($search_fields[$class] as $column) $search .= "OR $column REGEXP $search "; - $where[] = "FALSE $search"; + $sql_search = ''; + foreach($search_fields[$class] as $column) $sql_search .= "OR $column REGEXP $search "; + $where[] = "FALSE $sql_search"; } elseif($id) $where[] = "$class$suffix_id = $id"; if(!$history && $this->contains_history($class)) $where[] = $class.'_valid_till=0'; - if($where) $sql .= 'WHERE '.implode(' AND ', $where)."\n"; + if($where) $sql .= 'WHERE ('.implode(') AND (', $where).")\n"; //ORDER if(!$order) $order = $class.$suffix_id; if($this->contains_history($class)) $order .= ",${class}_valid_from DESC"; -- 2.30.2