Dear all,
im trying to create a JSON file from a mySQL Database Table.
the table looks like this:
ID|Street|City|Type|FirstName|LastName
1|Somewherestreet|Somewherecity|Familyhead|Chris|Somebody
1|Somewherestreet|Somewherecity|FamilyMember|Anna|Somebody
1|Somewherestreet|Somewherecity|FamilyMember|Frank|Somebody
the desired output should look like this
"ID":"1",
"Street":"Somewherestreet",
"City":"Somewherecity"
"Type": "FamilyHead",
"FirstName": "Chris",
"LastName": "Somebody",
"Members":[
{"FirstName": "Anna",
"LastName": "Somebody"},
{"FirstName": "Frank",
"LastName": "Somebody"}
],
"ID":"2",
....
Ho can i group the data and create a clean nested json?
Any hint would be helpful
Regards,
Christian
