Ok lo que pasa es que tengo 2 consulta para hacer
tengo una consulta de categorias para obtener todas las categorias de la tabla y luego dentro de esa categoria quiero meter todas las movie que trae esa categoria
Ejemplo json:
Código json:
Ver original{
"categories": [
{
"title":"Categoria 1",
"items": [
{
"description": "Welcome to the Hotel Transylvania, Draculas lavish five-stake resort, where monsters and their families can live it up, free to be the monsters they are without humans to bother them. On one special weekend, Dracula(Adam Sandler) has invited all his best friends - Frankenstein and his wife, the Mummy, the Invisible Man, the Werewolf family, and more - to celebrate his beloved daughter Mavis' 118th birthday. For Dracula catering to all of these legendary monsters is no problem but the party really starts when one ordinary guy stumbles into the hotel and changes... ",
"director": "Director: Genndy Tartakovsky",
"id": "0",
"image": "assets/largeRowImage1.jpg",
"largeRowImage": "https://s3.amazonaws.com/flicdn/roku/flicast/demo_media/largeHotelTrans.jpg",
"remotePoster" : "https://s3.amazonaws.com/flicdn/roku/flicast/demo_media/poster_hoteltransylvania.jpg",
"movieLength": "| 1h 31m |",
"movieLengthShort": "",
"movieYear": " 2012 |",
"ratingPic": "assets/ratings/rating-pg-wt-fhd.png",
"mpaaRating":"pg",
"springboardBackground": "assets/show_bg/",
"starRating": "assets/stars_5_fhd.png",
"stars": 5,
"thumbPic": "assets/poster_hoteltransylvania.jpg",
"title": "Hotel Transylvania",
"trailerURL":"http://flicdn.s3.amazonaws.com/roku/flicast/demo_media/hoteltansylvania-tlr1_h720p_3mbps.mp4",
"streamURL":"http://flicdn.s3.amazonaws.com/roku/flicast/demo_media/hoteltansylvania-tlr1_h720p_3mbps.mp4",
"duration":153
}
]
},
{
"title":"Categoria 2",
"items": [
{
"description": "Welcome to the Hotel Transylvania, Draculas lavish five-stake resort, where monsters and their families can live it up, free to be the monsters they are without humans to bother them. On one special weekend, Dracula(Adam Sandler) has invited all his best friends - Frankenstein and his wife, the Mummy, the Invisible Man, the Werewolf family, and more - to celebrate his beloved daughter Mavis' 118th birthday. For Dracula catering to all of these legendary monsters is no problem but the party really starts when one ordinary guy stumbles into the hotel and changes... ",
"director": "Director: Genndy Tartakovsky",
"id": "0",
"image": "assets/largeRowImage1.jpg",
"largeRowImage": "https://s3.amazonaws.com/flicdn/roku/flicast/demo_media/largeHotelTrans.jpg",
"remotePoster" : "https://s3.amazonaws.com/flicdn/roku/flicast/demo_media/poster_hoteltransylvania.jpg",
"movieLength": "| 1h 31m |",
"movieLengthShort": "",
"movieYear": " 2012 |",
"ratingPic": "assets/ratings/rating-pg-wt-fhd.png",
"mpaaRating":"pg",
"springboardBackground": "assets/show_bg/",
"starRating": "assets/stars_5_fhd.png",
"stars": 5,
"thumbPic": "assets/poster_hoteltransylvania.jpg",
"title": "Hotel Transylvania",
"trailerURL":"http://flicdn.s3.amazonaws.com/roku/flicast/demo_media/hoteltansylvania-tlr1_h720p_3mbps.mp4",
"streamURL":"http://flicdn.s3.amazonaws.com/roku/flicast/demo_media/hoteltansylvania-tlr1_h720p_3mbps.mp4",
"duration":153
}
]
},
]
}