Hi all! So I've been reading about the "FOR XML AUTO" function which sounds great, but it hasn't been working when I try it in phpmyadmin. I get an error in the area of "FOR XML AUTO", I know SimpleXML is disabled on my package but would that be why it's not working there? Once I get that to work, I need any values with a similar column to combine, such as:
orders cname cadd
1000 Name1 Address1
2000 Name2 Address2
2000 Name3 Address3
I need the output to be:
<orders value="1000"> <cname value="Name1"> <cadd>Address 1</cadd> </cname> </orders> <orders value="2000"> <cname value="Name 2"> <cadd>Address 2</cadd> </cname> <cname value="Name3"> <cadd>Address 3</cadd> </cname> </orders>
See how the ones with the similar index merge? THANKS SO MUCH :). Any help is appreciated!