Sorry I forgot to mention i added BalanceGP to wp_users 🙂 The First bit didn’t work but then i used this – SELECT display_name,BalanceGP FROM wp_users WHERE ID = ‘<?php $current_user->ID ?>’ It is now showing. This is probably the stupidest way to do it but what i’m trying to achieve is when a user has paid for something it updates the balance P.s I’m really new to coding xD
i want to be able to update the users value of a column e.g. balance, I’ve tried using this but can’t get it to work –
SELECT display_name,BalanceGP FROM wp_users UPDATE table SET BalanceGp = BalanceGP + 1 WHERE ID = 11
