I have an XML format that i'm downloading from a server that looks something like this...
Since all of the column headings are wrapped in the <COLUMNS> record and each set of data is in the <DATA> record and separated by tabs, what is a good way to parse this with PHP?
The ultimate goal is to push the data into my MySQL db.
<SETME ReplyCode="0" ReplyText="Operation Successful">
<COLUMNS>Favorite Fruit Favorite Sandwich Favorite TV Show</COLUMNS>
<DATA>Watermelon Peanut butter and Jelly Beverly Hillbillies</DATA>
<DATA>Apple Pastrami on Rye NYPD Blue</DATA>
<DATA>Orange Hamburger Star Trek</DATA>