thisistrav

Hey Guy,

Would certainly appreciate more info on the solution you found please, if you wouldn’t mind?

Thanks in advance.

Sorry, testing code up there ^.

With SQL injection protection on… last line reads…

return $wpdb->get_var($wpdb->prepare(“SELECT field FROM table WHERE field = ‘$current_user->user_login'”));

OK, so all I apparently needed was another half a day.

I used the plugin: Shortcode Exec PHP, then created a shortcode for the below code:

global $wpdb;
global $current_user;
$current_user = wp_get_current_user();
return $wpdb->get_var(“SELECT field FROM table WHERE field = ‘$current_user->user_login'”);

… with “output echoed” unticked.

The shortcode then easily placed in a page.

I believe I was close on a number of occasions way back, but had the quotes mixed up on the $current_user->user_login variable.

Glad that’s over. Next challenge now. Hope that might help someone else.