CSV DAtei formatieren

Select distinct
spalten.aus.tabellen
INTO OUTFILE->datei.csv'
FIELDS
      TERMINATED BY->|'
      OPTIONALLY ENCLOSED BY->'
From
tabellen
Where
order_status =->P' and username=$name
Order By
mos_pshop_order_user_info.order_id Asc

/
header(Content-Type: text/plain);
header(Content-Disposition: attachment; filename=.$datei..csv);


$result = mysql_query(Select distinct
mos_pshop_order_user_info.last_name,
mos_pshop_order_user_info.first_name,
mos_pshop_order_user_info.phone_1,
mos_pshop_order_user_info.fax,
mos_pshop_order_user_info.address_1,
mos_pshop_order_user_info.city,
mos_pshop_order_user_info.state,
mos_pshop_order_user_info.country,
mos_pshop_order_user_info.zip,
mos_pshop_order_user_info.user_email,
mos_pshop_orders.order_id,
mos_pshop_orders.order_total,
mos_pshop_orders.order_status,
mos_pshop_orders.order_currency,
mos_pshop_order_item.product_id,
mos_pshop_order_item.product_quantity,
mos_pshop_order_item.order_item_sku,
mos_pshop_order_item.order_item_name,
mos_pshop_order_item.product_item_price,
mos_pshop_order_item.product_final_price,
mos_users.username
From
mos_pshop_order_user_info
Inner Join mos_pshop_orders ON mos_pshop_orders.order_id = mos_pshop_order_user_info.order_id
Inner Join mos_pshop_order_status ON mos_pshop_orders.vendor_id = mos_pshop_order_status.vendor_id
Inner Join mos_pshop_order_item ON mos_pshop_orders.order_id = mos_pshop_order_item.order_id
Inner Join mos_users ON mos_pshop_order_user_info.user_id = mos_users.id
Where
mos_pshop_orders.order_status =->C' and mos_users.username=$name
Order By
mos_pshop_order_user_info.order_id Asc);
if ($data = mysql_fetch_array($result)){
$datei.=A|;$data[last_name];$data[first_name];$data[address_1];$data[zip];$data[city];$data[phone_1];$data[fax]\n;
}
while ($data = mysql_fetch_array($result)){
$datei.=B|;$data[order_id];$data[order_total];$data[order_item_name]\n;
}

print $datei;

<?php
.....
.....
$fh = fopen(test.csv, w);
if ($data = mysql_fetch_array($result)){
  fwrite($fh,A|;$data[last_name];$data[first_name];$data[address_1];$data[zip];$data[city];$data[phone_1];$data[fax]\n);
}
while ($data = mysql_fetch_array($result)){
  fwrite($fh, B|;$data[order_id];$data[order_total];$data[order_item_name]\n);
}
fclose($fh);
?>

A|test|test|test|23412|test|123124|
A|test|test|test|23412|test|123124|
B|20|71.00|AGW.001
A|test|test|test|23412|test|123124|
B|20|71.00|AGW.001
B|21|11.00|AGW.009
A|test|test|test|23412|test|123124|
B|20|71.00|AGW.001
B|21|11.00|AGW.009
B|22|0.00|HFS.001
A|test|test|test|23412|test|123124|
B|20|71.00|AGW.001
B|21|11.00|AGW.009
B|22|0.00|HFS.001
B|23|496.00|EWA02.012

$fh = fopen(test, w);
$result = mysql_query(Select distinct...);
if ($data = mysql_fetch_array($result)){
fwrite($fh,$datei.=A|$data[last_name]|$data[first_name]|$data[address_1]|$data[zip]|$data[city]|$data[phone_1]|$data[fax]\n);
}
$result = mysql_query(Select distinct...);
while ($data = mysql_fetch_array($result)){
  fwrite($fh, $datei.=B|$data[order_id]|$data[order_total]|$data[order_item_name]\n);
}
fclose($fh);

<?php
$sql = Select distinct
			t1.last_name, t1.first_name, t1.phone_1, t1.fax, t1.address_1, 
			t1.city, t1.state, t1.country, t1.zip, t1.user_email, 
			t2.order_id, t2.order_total, t2.order_status, t2.order_currency, 
			t3.product_id, t3.product_quantity, t3.order_item_sku, t3.order_item_name, 
			t3.product_item_price, t3.product_final_price, 
			t5.username 
		From 
			mos_pshop_order_user_info t1 
		Inner Join 
			mos_pshop_orders t2 ON t2.order_id = t1.order_id
		Inner Join 
			mos_pshop_order_status t4 ON t2.vendor_id = t4.vendor_id 
		Inner Join 
			mos_pshop_order_item t3 ON t2.order_id = t3.order_id 
		Inner Join mos_users t5 ON t1.user_id = t5.id 
		Where
			t2.order_status =->C' and t5.username='.$name.' 
		Order By
			t1.order_id ASC;

$fh = fopen(test.csv, w);

if ($res = mysql_query($sql)){
	$i = 0;
	while ($data = mysql_fetch_array($res)){
		if($i==0) fwrite($fh, A|;$data[last_name];$data[first_name];$data[address_1];
                         $data[zip];$data[city];$data[phone_1];$data[fax]\n);
		fwrite($fh, B|;$data[order_id];$data[order_total];$data[order_item_name]\n);
		++$i;
	}
}
fclose($fh);
?>

mysql_fetch_array($result)

mysql_fetch_array($sql)