how to add a value to a custom column

hi and thank you for your great shop
i created a payment type on my country and when the payment is done, i want to add a custom reference value to a custom column i created inside the jos_hikashop_order table.

The value is "referencia". this value is for payments done in ATM in my country wich are very popular (in Portugal)
so i created the "multibanco" payment option and it works, it generates the reference to wich people have to pay, and also sends an e-mail to our clients with that reference but i need to add this value to the database to keep track of things in the future.
on my multibanco.php i added:

$db =& JFactory::getDBO();
$query = 'UPDATE '.hikashop::table('order').' SET referencia ='.$referencia2.' WHERE order_id ='.$order->order_id'';
$db->setQuery($query);
$result = $db->query();

hi mate thank you for your fast reply i tested and it still does not work.

it's like this:

$db =& JFactory::getDBO();
$query = 'UPDATE '.hikashop::table('order').' SET referencia ='.$db->Quote($referencia2).' WHERE order_id ='.(int)$order->order_id;
$db->setQuery($query);
$result = $db->query();

hi mate here is the code:
pastebin.com/9UhBgTf6
it will work for 24 hours
you can see the full multibanco payment system.
please dont laught at the "mess" of my code, at least part of it works
thanks

hi, thank you very much, i also set that variable as global so i dont have more problems. it's only used on the payment action and only if the payment is ATM so i will not touch it again soon.

once again thank you very much

Hello,

I have a similar situation: we need the same system: "Multibanco" references sent to the customer. This is a very popular payment system here in Portugal.

Can anyone share any code to be used as a reference so that I can create a custom payment in Hikashop?

Thank you for any help!