Title: wpdb mysql_num_rows?
Last modified: August 20, 2016

---

# wpdb mysql_num_rows?

 *  [Anthony](https://wordpress.org/support/users/adzbierajewski/)
 * (@adzbierajewski)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/)
 * How do I use wpdb to get the number of rows in a table?

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Jackson Whelan](https://wordpress.org/support/users/madjax/)
 * (@madjax)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/#post-2310479)
 * > The results count for a ‘SELECT’ query will be stored in $wpdb->num_rows.
 * [http://codex.wordpress.org/Class_Reference/wpdb](http://codex.wordpress.org/Class_Reference/wpdb)
 *  Thread Starter [Anthony](https://wordpress.org/support/users/adzbierajewski/)
 * (@adzbierajewski)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/#post-2310481)
 * Is it possible that you post an example?
 *  [Rev. Voodoo](https://wordpress.org/support/users/rvoodoo/)
 * (@rvoodoo)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/#post-2310482)
 * [http://wp.smashingmagazine.com/2011/09/21/interacting-with-the-wordpress-database/](http://wp.smashingmagazine.com/2011/09/21/interacting-with-the-wordpress-database/)
 * Here’s a killer article which may have some help too
 *  [Jackson Whelan](https://wordpress.org/support/users/madjax/)
 * (@madjax)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/#post-2310484)
 * The smashing article is a great resource.
 * You need to make a query, then access the variable with the number of rows, ie:
 *     ```
       global $wpdb;
       $wpdb->get_results( 'SELECT COUNT(*) FROM table_name' );
       echo  $wpdb->num_rows . 'Rows Found';
       ```
   
 *  Thread Starter [Anthony](https://wordpress.org/support/users/adzbierajewski/)
 * (@adzbierajewski)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/#post-2310544)
 * Thank you guys very much!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘wpdb mysql_num_rows?’ is closed to new replies.

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 5 replies
 * 3 participants
 * Last reply from: [Anthony](https://wordpress.org/support/users/adzbierajewski/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/wpdb-mysql_num_rows/#post-2310544)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics