New Contribution Order Export

[mightyx]

Hello, I am currently building a order export contribution, based on an already existing contrib. I want to adopt it for some specials I need, for example German bank transfer.

Now I wrote a query that defines the bank account variables I want to export. My problem:

If a customer pays by Paypal, no bank account data is inserted in the database. That means some order IDs have bank account data, some don't have an entry in the benktransfer table.

If I look at my export file, the last bank account data is repeated until the next customer inserts bank account data. Is there a function to "select only if order ID in table banktrnasfer exists"?

 

Here's my code:

 

//Bankdaten f?r Lastschrift

$banktransfer = tep_db_query("select banktransfer_owner, banktransfer_bankname, banktransfer_blz, banktransfer_number from banktransfer

where orders_id = " . $Orders_id);

//$row_banktransfer = tep_db_fetch_array($banktransfer);

while($row_banktransfer = mysql_fetch_array($banktransfer)) {

// end //

 

$bt_owner = filter_text($row_banktransfer["banktransfer_owner"]);

$bt_bankname = filter_text($row_banktransfer["banktransfer_bankname"]);

$bt_blz = filter_text($row_banktransfer["banktransfer_blz"]);

$bt_number = filter_text($row_banktransfer["banktransfer_number"]);

}