"; $pieces = explode(",", $pp); // var_dump( $pieces ); echo QrStr($pieces). "
";; } fclose($myfile); function QrStr( $pieces ){ $nm = explode(" ", trim($pieces[1])); $lastName = $nm[ count($nm) -1 ]; $midName = ""; // trim( $nm[ count($nm) -2 ] ); return "INSERT INTO market_import(email,name,firstname,lastname,middlename, phone,promo) VALUES ('".trim($pieces[2])."','".trim($pieces[1])."','".$nm[0]."','".$lastName."','".$midName."','".trim($pieces[6])."','LIVE0IFE');"; }