Adam2500

Many thanks Barand, its still not the correct format though. This is what its returning: array(2) { [1]=> array(3) { ["catid"]=> string(1) "1" ["catname"]=> string(14) "Category 1" ["videos"]=> array(3) { [0]=> array(4) { ["vidname"]=> string(29) "Song Name" ["vidthumbnail"]=> string(73) "https://webiste.com/thumbnail.jpg" ["vidid"]=> string(1) "3" ["vidlink"]=> string(61) "https://www.youtube.com/" } [1]=> array(4) { ["vidname"]=> string(17) "Song Name" ["vidthumbnail"]=> string(73) "https://webiste.com/thumbnail.jpg" ["vidid"]=> string(1) "2" ["vidlink"]=> string(61) "https://www.youtube.com" } [2]=> array(4) { ["vidname"]=> string(16) "Song Name" ["vidthumbnail"]=> string(76) "https://webiste.com/thumbnail.jpg" ["vidid"]=> string(1) "1" ["vidlink"]=> string(61) "https://www.youtube.com" } } } [2]=> array(3) { ["catid"]=> string(1) "2" ["catname"]=> string(10) "Category 2" ["videos"]=> array(1) { [0]=> array(4) { ["vidname"]=> string(12) "Song Name" ["vidthumbnail"]=> string(72) "https://webiste.com/thumbnail.jpg" ["vidid"]=> string(1) "4" ["vidlink"]=> string(61) "https://www.youtube.com" } } } }

Thank you for the reply, it didnt seem to work though and is giving a different format than the one needed. array(2) { [1]=> array(3) { ["catid"]=> string(1) "1" ["catname"]=> string(14) "Category 1" ["videos"]=> array(3) { [0]=> array(4) { ["vidname"]=> string(29) "Song Name" ["vidthumbnail"]=> string(73) "https://website.com/thumbnail.jpg" ["vidid"]=> string(1) "3" ["vidlink"]=> string(61) "https://www.youtube.com" } [1]=> array(4) { ["vidname"]=> string(17) "Song Name" ["vidthumbnail"]=> string(73) "https://website.com/thumbnail.jpg" ["vidid"]=> string(1) "2" ["vidlink"]=> string(61) "https://www.youtube.com" } [2]=> array(4) { ["vidname"]=> string(16) "Song Name" ["vidthumbnail"]=> string(76) "https://website.com/thumbnail.jpg" ["vidid"]=> string(1) "1" ["vidlink"]=> string(61) "https://www.youtube.com" } } } [2]=> array(3) { ["catid"]=> string(1) "2" ["catname"]=> string(10) "Category 2" ["videos"]=> array(1) { [0]=> array(4) { ["vidname"]=> string(12) "Song Name" ["vidthumbnail"]=> string(72) "https://website.com/thumbnail.jpg" ["vidid"]=> string(1) "4" ["vidlink"]=> string(61) "https://www.youtube.com" } } } }

I need to generate an array exactly like the example, but its not working. Im using the following code: $res = prepareALL("SELECT c.id, c.name, f.id as fid, f.name as fname, f.link as flink, f.thumbnail as fthumbnail FROM video_categories c left outer join videos f on c.id=f.category", array()); $categories = array(); foreach($res as $videos){ $categories[$videos['id']]['id'] = $videos['id']; $categories[$videos['id']]['name'] = $videos['name']; $categories[$videos['id']]['videos'][] = array( 'id' => $videos['fid'], 'name' => $videos['fname'], 'link' => $videos['flink'], 'thumbnail' => $videos['fthumbnail'] ); } var_dump($categories); This is outputting array(2) { [1]=> array(3) { ["id"]=> string(1) "1" ["name"]=> string(14) "Category 1" ["videos"]=> array(3) { [0]=> array(4) { ["id"]=> string(1) "2" ["name"]=> string(17) "Song Name" ["link"]=> string(61) "https://www.youtube.com" ["thumbnail"]=> string(73) "https://website.com/thumbail.jpg" } [1]=> array(4) { ["id"]=> string(1) "1" ["name"]=> string(16) "Song Name" ["link"]=> string(61) "https://www.youtube.com" ["thumbnail"]=> string(76) "https://website.com/thumbail.jpg" } } } [2]=> array(3) { ["id"]=> string(1) "2" ["name"]=> string(10) "Category 2" ["videos"]=> array(1) { [0]=> array(4) { ["id"]=> string(1) "4" ["name"]=> string(12) "Song Name" ["link"]=> string(61) "https://www.youtube.com" ["thumbnail"]=> string(72) "https://website.com/thumbail.jpg" } } } } I need it to export exactly like this though: [ { "catName": "Category 1", "catID": "1", "videos": [ { "vidName": "Song Name", "vidThumbnail": "https://website.com/thumbnail.jpg", "vidID": "3", "vidLink": "https://www.youtube.com" }, { "vidName": "Song Name", "vidThumbnail": "https://website.com/thumbnail.jpg", "vidID": "3", "vidLink": "https://www.youtube.com" } ] }, { "catName": "category 2", "catID": "2", "videos": [ { "vidName": "Song Name", "vidThumbnail": "https://website.com/thumbnail.jpg", "vidID": "", "vidLink": "https://www.youtube.com" }, { "vidName": "Song Name", "vidThumbnail": "https://website.com/thumbnail.jpg", "vidID": "", "vidLink": "https://www.youtube.com" } ] } ]