The data in my table looks like:
Batch Image name age
1 1 Alfa 20
1 2 Beta 14
1 2 Theta 46
1 2 omega 9
How can get this output into this format:
<Batch name='1'>
<Image name='1'>
<fld name>Alfa</fld>
<fld age>20</fld>
</image>
<Image name='2'>
<fld name>Beta</fld>
<fld age>14</fld>
<fld name>theta</fld>
<fld age>46</fld>
<fld name>omega</fld>
<fld age>9</fld>
</image>
</Batch>Kennedy Nyagah Njagi Kairaria IT Support-Applications development, Digital Divide Data
Tel: 254 772191795 | Mobile: 254 724615232
kennedy.kairaria@digitaldividedata.com | www.digitaldividedata.com
