how to use SQL transaction

[adller99]

Hi,

 

I need to use sql transaction for incrementing referender order number. The client wants to have the reference number incremented by 1.

So I've decided to modify generateReference() method within Order class.

 

$custom_last_order_id = Db::getInstance()->getValue('SELECT MAX(reference) AS order_reference FROM '._DB_PREFIX_.'orders ');

        

return $custom_last_order_id+1;

 

how do I secure this to be transactioned?

 

thanks