Hi Guys,

i have this piece of code below working great when echoed out displays the files like it should, they can be upto 100 lines depending, what i wanted to do is store ALL the date for "$output" & "$parts" in mysql but it only stores the first line not the rest, if i put my insert query in the foreach it inserts the files but makes an entry for each file (instead of the whole lot in the 1 field)

PHP Code:
     //================================================================================//
     // Before the insertion get some details...
     //================================================================================// 
     $filecontent = file_get_contents("nzbs/$renamed_nzb");
     
     $parts = explode("</file>",$filecontent);
     
     foreach($parts as $part){
     
            ## get the newsgroup
            if (eregi ('subject="(.*)">', $part, $matches)) {
            $titel = $matches[1];
            $titel = explode('">', $titel);
            print('<font face=Verdana size=1>'.$titel[0]."");
            }
     
            if (eregi("<group>(.*)</group>", $part, $matches)) {
            $ng = $matches[1];
            $ng = str_replace("alt.binaries", "a.b", $ng);
            //echo ("<font face=Verdana size=1>".$ng."");            
            
            ## get the poster 
            
            if (eregi ("poster=\"(.*)\" date=", $part, $matches)) {
            $poster = $matches[1];
            //print("<font face=Verdana size=1>".$poster."");
            }
            
            if (eregi ("<segment bytes=\"(.*)\" number=", $part, $matches)) {
            $size = $matches[1];
            $size = round($size / 1024,2);
            $parts = doe_iets($titel[0]);
            $parts = str_replace("/", "", $parts);
            $parts = str_replace(")", "", $parts);
            $output = $parts * $size;
            print "$output kb $parts";
            
            $total_output = $output;
            
            }
            
            
         }
                        
    } 
is there a way i can store the whole lot in mysql as 1 long string then ill be able to explode it and display later.

thanks for any help guys

Graham