+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Need Help with a MySQL Query (/showthread.php?tid=69649)
Need Help with a MySQL Query - sabimofler - 12-30-2017
Hello everyone,
I am finding difficulties to make a mysql query based on this idea:
Computer Science
- Dan Vick
- Harry Jones
Marketing
- John Doe
Business
- Leo Rodriguez
IT
- Tim Ben
![[Image: image.png]](https://s20.postimg.org/4yf86zrsd/image.png)
Could someone help me?
Thank you!
RE: Need Help with a MySQL Query - Wouter60 - 12-30-2017
PHP Code:
$query = $this->db->select('department,fullname')->from('employees')->order_by('department,fullname')->get();
$offset = '';
foreach($query->result() as $row) {
if ($row->department != $offset) {
echo '<h3>' . $row->department . '</h3>';
$offset = $row->department;
}
echo '- ' . $row->fullname . '<br />';
}
RE: Need Help with a MySQL Query - sabimofler - 12-30-2017
(12-30-2017, 05:44 AM)Wouter60 Wrote:PHP Code:$query = $this->db->select('department,fullname')->from('employees')->order_by('department,fullname')->get();
$offset = '';
foreach($query->result() as $row) {
if ($row->department != $offset) {
echo '<h3>' . $row->department . '</h3>';
$offset = $row->department;
}
echo '- ' . $row->fullname . '<br />';
}
Works as intended, many thanks Wouter60.