How do you turn this kind of API data into an SQL style while loop?
{
"product":[
{
"product_code":"3554",
"item":[
{
"item_code":"5296",
"title":"Item title",
"variation_name":"Small",
"author":"INZU",
"description":"Short production description",
"long_description":"Long production description",
"image":"http://media.inzu.net/user/images/5296_thumb.png",
"image_large":"http://media.inzu.net/user/images/5296_img.png",
"preview":"http://media.inzu.net/user/previews/preview_3554.jpg",
"price_uk":"30.99",
"price_us":"45.99",
"shipping_namerica_uk":"1.99",
"shipping_samerica_uk":"1.99",
"shipping_europe_uk":"1.99",
"shipping_world_uk":"1.99",
"shipping_namerica_us":"2.99",
"shipping_samerica_us":"2.99",
"shipping_europe_us":"2.99",
"shipping_world_us":"2.99",
"stock":"100",
"pages":"3",
"active":"1",
"tags":"Tag1, Tag2, Tag3"
},
{
"item_code":"5297",
"title":"Item title",
"variation_name":"Medium",
"author":"INZU",
"description":"Short production description",
"long_description":"Long production description",
"image":"http://media.inzu.net/user/images/5296_thumb.png",
"image_large":"http://media.inzu.net/user/images/5296_img.png",
"preview":"http://media.inzu.net/user/previews/preview_3554.jpg",
"price_uk":"30.99",
"price_us":"45.99",
"shipping_namerica_uk":"1.99",
"shipping_samerica_uk":"1.99",
"shipping_europe_uk":"1.99",
"shipping_world_uk":"1.99",
"shipping_namerica_us":"2.99",
"shipping_samerica_us":"2.99",
"shipping_europe_us":"2.99",
"shipping_world_us":"2.99",
"stock":"100",
"pages":"3",
"active":"1",
"tags":"Tag1, Tag2, Tag3"
}
]
}
]
}
this is the example from http://developers.inzu.net/feed_details/json.html
