XML -> Arrays

[brooky]

Hi I'm having real problems parsing an XML doc into eventaully and SQL statement.

I basically wnat to create two arrays.

<root>
  <child>
    <subchild1>value1</subchild1>
    <subchild2>value2</subchild2>
    <subchild3>value3</subchild3>
  </child>
</root>

The array of subchilds:
$subchildren = array (subchild1, subchild2, subchild3);

The array of values:
$vaules = array(value1, value2, value3);

Then I want to use these arrays to build an SQL statement which I feel happy I can do.

I've been testing code from http://php.net/xml but cannot work this out... 🙁