StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcodeigniter group_by returning only first row
text
Body
copied!<p>i have this problem in codeigniter: I try to make a navigation tree system from database.</p> <p>model: </p> <pre><code>function getServices() { $this->db->select('service_url, service_title, category_title'); $this->db->join('services_category', 'services_category.id=services.category_id'); $this->db->group_by('category_title'); $this->db->order_by('service_title', 'ASC'); $query = $this->db->get('services'); if($query->result() == TRUE) { foreach($query->result_array() as $row) { $result[] = $row; } return $result; } } </code></pre> <p>view:</p> <pre><code><?php if(isset($services) && $services) : foreach($services as $s) : ?> <ul> <li><a href="#"><?php echo $s['category_title'] ?></a> <ul> <li><?php echo anchor('services/' . $s['service_url'], $s['service_title']); ?></li> </ul> </li> </ul> <?php endforeach; ?> <?php endif; ?> </code></pre> <p>now so far so good, the result is returning each category the way is supposed to, but the service is returning only one service per category, and in some categories there is like 15 services. Anybody kind to give me a hand, or an explanation what is going wrong ? Thank you so much.</p> <p>"i'm not an expert in php or codeigniter, i just started not long time ago, so please don't shoot the beginner."</p> <p>note: i tried without the group_by and order_by, and is returning all services, but the categories are repeating,</p> <p>ex:</p> <pre><code>category-a service1 category-a service2 category-b service10 category-b service11 category-c service30 category-c service31 .... </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload