0

I have this sample code that I found online that's supposed to count the number of rows in a table. Of course... It works, but when I created my own table using phpMyAdmin... It no longer works. What am i doing wrong?

I'm also wondering whey the "wp_users" table name dosen't work, but "users" does..

My table name is "test" I've also tried "wp_test" but for some reason none of them work.

<?php

$user_count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->users");
echo "<p>User count is {$user_count}</p>";

?>

FYI, I never use forums so forgive me if i'm not doing something right.

3

1 Answer 1

3

Are you sure that's the table name? Usually on install WordPress prompts you to setup a table prefix so the default isn't wp_.

Additionally, you need to call the global $wpdb object so it's accessible to use:

global $wpdb;
$user_count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->users" );
echo "<p>User count is {$user_count}</p>";

Finally, to prevent the prefix issue you can call $wpdb->prefix:

global $wpdb;
$user_count = $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->prefix}users" );

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.