I have a situation with a MySQL query like this:
- Category1 - Item 1
- Category1 - Item 2
- Category1 - Item 3
- Category2 - Item 3
- Category2 - Item 4
- Category2 - Item 5
- Category2 - Item 1
- Category3 - Item 4
- Category3 - Item 10
- Category X - Item X or Item(1,2,3.... existing)
How can I group by category in PHP?
Database scheme:
MySQL query:
$query = "SELECT cat.category_name, ch.channel_name
FROM `type_categ` tc , `categories` cat , `channels` ch
WHERE cat.category_id = tc.category_id AND ch.channel_id = tc.channel_id
ORDER BY cat.category_name ASC"
Output:
var_dump($category)
array(x) {
[0]=> array(2) {
["category_name"]=> string(8) "Category1"
["channel_name"]=> string(15) "Item1"
}
[1]=> array(2) {
["category_name"]=> string(8) "Category1"
["channel_name"]=> string(17) "Item2"
}
[2]=> array(2) {
["category_name"]=> string(8) "Category1"
["channel_name"]=> string(10) "Otem 5"
}
... ...
[x]=> array(2) {
["category_name"]=> string(8) "Category x"
["channel_name"]=> string(10) "Item x"
}
}