07-27-2023, 09:42 AM
Ive Tried And Tried Looking Up How To Approach Editing/Updating Rows In Custom Wordpress Tables I Have It Set To Grab Current logged in user's username which then compares to a custom wp_ table With UserNAme As The Primary Key Which Then I Would Like To Edit A Particular Column/Field On That Particular Row By Passing The Value Of A Variable Over After It Confirms Current Logged In User Matches The Primary Key UserName In My Custom Table"wp_customers" What Am I Doing Wrong With This Line Of Code Or Do You Have A Better Solution
$current_user = wp_get_current_user();
$johnny = $current_user->user_login;
$subs = 'illinois';
global $wpdb;
$wpdb->query(
"
UPDATE $wpdb->wp_Customers
SET BuyersAddress = $subs
WHERE UserName = $johnny
");
$current_user = wp_get_current_user();
$johnny = $current_user->user_login;
$subs = 'illinois';
global $wpdb;
$wpdb->query(
"
UPDATE $wpdb->wp_Customers
SET BuyersAddress = $subs
WHERE UserName = $johnny
");