I am trying to update a row in a custom database table by $wpdb->update();
. In my opinion my code is right but for some reason my database row doesn't update.
Can anyone help me with this?
I want to update a the status of a transaction in the table wp_mollie_transactions where the transaction_id
is equal to the $order_id
, which I received from from my payment provider.
(Off course I made $wpdb
global in this file)
// Update database
$wpdb->update( $wpdb->prefix . 'mollie_transactions',
array(
'status' => $payment->status
),
array(
'transaction_id' => $order_id
)
);
$order_id
and$payment->status
are valid variables, and there is definitely an entry in the database with a matchingtransaction_id
? Make sure debugging is enabled and see ifwpdb
throws any errors.