putting customer_id on invoice

[dcoder50]

I am trying to place the customer_id on the invoice this is the code that I have:

 

$customer_id = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

 

it just shows Resource id #32

 

any ideas?

[♥ecartz]

$order_customer_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
$order_customer = tep_db_fetch_array($order_customer_query);
$customer_id = $order_customer['customers_id'];

I think that you skipped a couple steps.