i have this code to insert in mysql db from a xml file on my server

```
     $xml = simplexml_load_file('/var/www/file.xml');

foreach( $xml->product as $value )
foreach( $xml->product->fields as $categories ) 

{

        $name = mysql_real_escape_string($value->name);
        $number = mysql_real_escape_string($value->sku);
        $description = mysql_real_escape_string($value->description);
        $CategoryPath = mysql_real_escape_string($categories->breadCrumb);

        $sql = "
            INSERT INTO table SET 
                name = '$name',
                sku = '$number',
                description = '$description',
                category = '$CategoryPath'

        ";
        $rssql = mysql_query( $sql );

    }

```

This is the xml structure

```
<product>
<name>Ghost Design 2000 Supporto TV LCD rotation</name>   
<description>
description text...
</description>
<brand>MELICONI</brand>
<sku>8006023191062</sku>
<fields>
<breadCrumb>
Home|Tecnologia e intrattenimento|Tv, DVD, Home Cinema|Accessori Tv/Video|Supporti video
</breadCrumb>
  </fields>
</product>

```

I insert all records in my sql table but the field breadCrumb is not inserted correctly. It insert always the same breadCrumb data for all records.