You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND (m.publish=1) AND m.language = 'cz' ORDER BY m.order ASC' at line 1 search►

13:            $this->connection = new mysqli($db_host = 'localhost', $db_login, $db_pass, $db_select);
14:    
15:            $this->connection->set_charset("utf8");
16:            if (!$this->connection) {
17:                throw new Exception("Není conn");
18:            }
19:            $this->lang = $lang;
20:        }
21:    
22:        public function query($query) {
23:            return $this->connection->query($query);
24:        }
25:    
26:        #obecne smazani 1 zaznamu v tabulce
27:    

64:            }
65:        }
66:    
67:    #-----------------------------------------------------------------------------------------------------------------------------------------
68:    # fce na odkaz na selektovany menu;
69:    
70:        public function out_selected_menu($section) {
71:    
72:            // submenu - zajistuje aby zustalo vypsane i po kliku
73:            $query = 'SELECT m.*,u.id AS uid, u.name AS uname, u.email AS uemail FROM menu_' . $this->lang . ' AS m LEFT JOIN user AS u ON u.id = m.user_id WHERE m.id=' . $section . ' AND (m.publish=1' . $this->preview() . ') AND m.language = \'' . $this->lang . '\' ORDER BY m.order ASC';
74:            $result = $this->query($query);
75:            if (!$result) {
76:                throw new Exception();
77:            }
78:    

 1:    <?php
 2:    $topsrc = '';
 3:    if ($selmenu->selected_menu["image_logo_id2"] > 0) {
 4:        $topsrc = '/images/menu/image_logo_id2/' . $selmenu->selected_menu["image_logo_id2"] . '-' . $lang;
 5:    } else {
 6:        $topsection = $menu_path->chain[count($menu_path->chain) - 2];
 7:        $selmenutop = new Menu($lang);
 8:        $selmenutop->out_selected_menu($topsection);
 9:        if ($selmenutop->selected_menu["image_logo_id2"] > 0) {
10:            $topsrc = '/images/menu/image_logo_id2/' . $selmenutop->selected_menu["image_logo_id2"] . '-' . $lang;
11:        } else {
12:            $topsrc = '/images/upload/' . $settings->config["topimage"];
13:        }
14:    }
15:    

null

103:                    $itemeditable = '';
104:                }
105:            }
106:        } else {
107:            $editable = false;
108:            $itemeditable = '';
109:        }
110:    
111:        // vyber sablony
112:        if ($template) {
113:            include 'templates/' . $template;
114:        } else {
115:            include 'templates/template_hp.php';
116:        }
117:    

'/var/www/clients/client143/web844/web/templates/template_in.php'