customers_id variable

[compuskill]

Hi there,

 

In a payment module, I need to use a mysql query containing the customers_id, but the problem is that the customers_id does not seem to be available in that module. That means: A mysql query works fine directly in the checkout_payment.php, but when I put the query into the payment module, it does not work anymore.

 

What can I do to use the variable in my module?

 

This is my query:

 

$invoice_query = tep_db_query("select value from customers_to_extra_fields where customers_id='".$customer_id."'");

 

Thx for helping.

[germ]

This may work:

 

$invoice_query = tep_db_query("select value from customers_to_extra_fields where customers_id='".(int)$customer_id."'");

[compuskill]

This may work:

 

$invoice_query = tep_db_query("select value from customers_to_extra_fields where customers_id='".(int)$customer_id."'");

 

Thanks for the reply. Unfortunately, that does not work work neither...

[compuskill]

Thanks for the reply. Unfortunately, that does not work work neither...

 

I guess I have it now. Just in case anyone is interested in it:

 

You can make the variables available this way:

global $your_variable;