$wpdb->wp_users returning empty value for

Question

I have a code Example:

function custom_func(){
    global $wpdb;
    $wpdb->flush();     //tried with and without this line
    $getTest = 'SELECT * FROM $wpdb->wp_users LIMIT 1';
    $arrayReturned = $wpdb->get_results($wpdb->prepare($getTest));
}

From what I've read I thought that $wpdb->wp_users is meant to have returned the database name and table name like so dbName.tableName; but it just returns an empty value.

I've tried:

$getTest = 'SELECT * FROM $wpdb->wp_users LIMIT 1';

which shows as the following to wordpress:

SELECT * FROM $wpdb->wp_users LIMIT 1

and

$getTest = 'SELECT * FROM '.$wpdb->wp_users.' LIMIT 1';

which shows as the following to wordpress:

SELECT * FROM  LIMIT 1

I can't fathom why this isn't working since this is all based on literature from the wordpress codex, any thoughts?

Kumar · Accepted Answer · 2014-03-25 20:44:30Z

0

First of all why you would need custom query for this basic functionality to get users, when WordPress has inbuilt function get_users().

Anyway for custom query, table name is defined as

function custom_func(){
 global $wpdb;
 $getTest = "SELECT * FROM $wpdb->users LIMIT 1";
 $arrayReturned = $wpdb->get_results($wpdb->prepare($getTest));
}

It's $wpdb->users or $wpdb->post and not $wpdb->wp_users, what you use for a table name, in custom queries.

Also I've used the double quotes " " for query and not single quotes ' ', you can read here

answered Mar 25, 2014 at 20:44

Kumar

2,88919 silver badges19 bronze badges

This was just a test example based on what I was reading, but you fixed all of the problems I was having with the table name changes, thanks.

VikingGoat
– VikingGoat

2014-03-26 17:17:13 +00:00
Commented Mar 26, 2014 at 17:17
Hope you could commit to community too :)

Kumar
– Kumar

2014-03-26 20:23:52 +00:00
Commented Mar 26, 2014 at 20:23

Add a comment |

Stack Exchange Network

$wpdb->wp_users returning empty value for

1 Answer 1

Your Answer

Hot Network Questions

$wpdb->wp_users returning empty value for

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions