Post
by girock » Tue Apr 13, 2010 2:41 am
My problem is not with css code but with opencart database query.
I don't know where is the query for third level here:
public function fetchCategories(){
$query = $this->db->query("SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE cd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY c.sort_order");
return $query->rows;
}
public function fetchCategory($category_id = 0){
$query = $this->db->query("SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '" . (int)$category_id . "' AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY c.sort_order");
return $query->rows;
This is the code in the catalog/model/catalog/category.
If I use only css for create my menu the third category is visible but I must to click for view subcategory