I need PHP5 Code that reads an array of XML file (Sample Range is
0100-1000.xml) and breaks each field down into a string so it can be
saved into a MySQL database. Bellow is a sample XML file.

~~~ This is an example of a XML File that needs to be read ~~~
<?xml version="1.0" encoding="iso-8859-1"?>
<testcell>
  <id>12345</id>
  <displayinfo>12345</displayinfo>
  <entered>2006-02-25 13:28:12</entered>
  <first>0</first>
  <image>./img/type1.jpg</image>
  <itemclass>1</itemclass>
  <itemid>12345</itemid>
  <name>Gear #1</name1>
  <version>37</version>
</testcell>

~~~~~ End of File ~~~~~

Here's how:

<?

$xmlfiles = range(1,1);

foreach ( $xmlfiles as $i)
{
        $cols = "";
        $vals = "";

        $f = sprintf("%04d.xml", i);

        $testcell = simplexml_load_file($f);

        $a = get_object_vars($testcell);

        $cols = implode(",", array_keys($a));
        $vals = "'".implode("','", array_values($a))."'";

        $sql = sprintf("INSERT INTO testcell (%s) VALUES (%s)", $cols, $vals);

        print($sql."\n");

        // mysql_query($sql);
}

?>

it is 99% there. I'm having a problem. The first file it is scanning
is 0000.xml. My first file is 0100.xml since there is no 0000 station.
I tried playing with the range but it always tries to start off at
0000.xml

$f = sprintf("%04d.xml", i);


after a little bit of trial I found out that "i" should have been "$i"
and it was filling 0000 due to the formatting on the line. since there
was no i it just filled it with all zeros.

Thank You very much!