Help inserting data into mysl

[graham23s]

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)

 

     //================================================================================//
     // 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

[Barand]

Do you need

 

$total_output .= $output;

[graham23s]

Hi Barry,

 

that was my desperate attempt lol i thought if i put it in another variable, i could insert that variable into mysql

 

it works but still only inputs the first line.

 

Graham

[Barand]

Attach the input file so we can run your code