<?

$host = '127.0.0.1';
$user = 'root';
$pass = '';
$db   = 'name';

$link_id=mysql_connect($host ,$user ,$pass);
$selecting_base=mysql_select_db($db);

$handle = fopen('in.txt', 'r');

while (!feof($handle)) {
    $buffer = fgets($handle, 4096);
    $raw = explode('|', $buffer);

    $sql = "SELECT Bcountry,BfirstName,BlastName,Baddress,Bcity,BpostalCode,Bstate,Bphone,Bemail FROM `orders` where id=".$raw[0];
    $q = mysql_query($sql);

    while($r = mysql_fetch_array($q, MYSQL_NUM)){
        $text .= $r[0].', '.$r[1].', '.$r[2].', '.$r[3].', '.$r[4].', '.$r[5].', '.$r[6].', '.$r[7].', '.$r[8].'|'.$raw[0].'|'.$raw[1].'|'.$raw[2]."\n";
    }

}

fclose($handle);
mysql_close($link_id);

$fp = fopen('file.txt', 'w+');
fwrite($fp, $text); // Запись в файл
fclose($fp);


?>