JSON to mysql with php

[mooserider2]

Ok I understand how to get normal JSON files into php variables with json_encode(); However, the json file I'm working with looks something like this:

{"daily":
{"1319846400000":250,"131993280000000",189"},"average":
{"1319846400000":190,"131993280000000",189"}}

There are 180 different daily prices with a 180 day running average (the long row of numbers is a timestamp in ms from Jan 1, 1970).

My question is how do I import this data into a table with id, timestamp, price, 180_average, one row per day?

[mooserider2]

Perhaps I could take the array made by json_decode() and do a foreach() but it is still nested strangely. Possibly a double foreach()? Like:

foreach($out["daily"] as $myarray) {
     foreach ($myarray as $key => $value) {
    
     }
}

I don't really know where to go from there. Possibly turn each part on the array into a string and put those strings into the database. How would I do that? Sorry I have been away from php for a while

http://www.webmasterworld.com/forum88/3811.htm this is what gave me the foreach() idea.