title: Using PHP to convert XML data
body: <p>I need to take XML DATA and upload all of it into my MySQL database. (right-click, save as...)</p>
  
  <p>Here's my theory...</p>
  
  <p>Take this line for example:</p>
  
  <blockquote>
    <p>monster short="Fredzin the crazed Dwarf" info="aggr, kungfu,
    cancellation" race="Dwarf" eq="A cheaply made grey shirt, A pressed
    pair of black trousers" exp="120280" palpoints="93" align="evil"
    god="Teros"</p>
  </blockquote>
  
  <p>I want to find the index of "short=" and then find the index of the quote marks following  the word Dwarf so that "Fredzin the crazed Dwarf" is the value that will be uploaded. But I can't figure out how to find the index of the 2nd quote mark, and then capture everything in between.</p>
  
  <p>I need to do this for ALL XML attribute values. Keep in mind that not all of the XML has the same attributes. So I don't think I can do something like - gather all of the "short" values, upload to db, then go through and gather the "exp" values, etc. I need to do one line at a time to ensure that the XML data is uploaded to the proper record in the db.</p>
  
  <p>Any suggestions? I've tried a few variations of substr(), simpleXML, explode() and fopen() but to no avail... yet.</p>