StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POworking with join query's result
text
Body
copied!<p>I have two tables Resources and Categories. I have made a join query and got the result. But I dont know how to work around it. Below is outputted result array. </p> <pre><code>array (size=4) 0 => array (size=5) 'resourceID' => string '24' (length=2) 'resourceName' => string 'Tafe Resources' (length=14) 'categoryID' => string '3' (length=1) 'categoryName' => string 'Accounting' (length=10) 'subcategoryID' => string '0' (length=1) 1 => array (size=5) 'resourceID' => string '24' (length=2) 'resourceName' => string 'Tafe Resources' (length=14) 'categoryID' => string '4' (length=1) 'categoryName' => string 'Adult Tertiary' (length=14) 'subcategoryID' => string '0' (length=1) 2 => array (size=5) 'resourceID' => string '26' (length=2) 'resourceName' => string 'College Resources' (length=17) 'categoryID' => string '7' (length=1) 'categoryName' => string 'Automotive' (length=10) 'subcategoryID' => string '0' (length=1) 3 => array (size=5) 'resourceID' => string '26' (length=2) 'resourceName' => string 'College Resources' (length=17) 'categoryID' => string '8' (length=1) 'categoryName' => string 'Busniess & Management' (length=21) 'subcategoryID' => string '0' (length=1) </code></pre> <p>this was my query </p> <pre><code>$this->db->select()->from('resources'); $this->db->join('categories','resources.resourceID = categories.resourceID'); </code></pre> <p>if it was from single table i will use for-each loop and get data. I want the duplicated columns to be merged. I want to display a table where resourceID and resourceName is unique.</p>

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