Title: annujames's Replies | WordPress.org

---

# annujames

  [  ](https://wordpress.org/support/users/annujames/)

 *   [Profile](https://wordpress.org/support/users/annujames/)
 *   [Topics Started](https://wordpress.org/support/users/annujames/topics/)
 *   [Replies Created](https://wordpress.org/support/users/annujames/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/annujames/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/annujames/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/annujames/engagements/)
 *   [Favorites](https://wordpress.org/support/users/annujames/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [Issue while fetching data from wordpress database custom table](https://wordpress.org/support/topic/issue-while-fetching-data-from-wordpress-database-custom-table/)
 *  Thread Starter [annujames](https://wordpress.org/support/users/annujames/)
 * (@annujames)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/issue-while-fetching-data-from-wordpress-database-custom-table/#post-1022137)
 * Hi Michael,
 * Thanks for guiding me to the rite direction, I went to wpdb page and found a 
   solution. It has explaned everything.
 * Thanks,
    James
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [Issue while fetching data from wordpress database custom table](https://wordpress.org/support/topic/issue-while-fetching-data-from-wordpress-database-custom-table/)
 *  Thread Starter [annujames](https://wordpress.org/support/users/annujames/)
 * (@annujames)
 * [17 years, 2 months ago](https://wordpress.org/support/topic/issue-while-fetching-data-from-wordpress-database-custom-table/#post-1022134)
 * I used get_results aswell, however, in output it is showing up the same single
   result, where as the output is 3 records. If you see following code the result
   for post_count is coming up 3 but for mypost it showing up single record, how
   do I print all the 3 results?
 * function my_posts()
    { global $wpdb; $checkpost = $wpdb->get_results(“SELECT 
   record_content as mypost, COUNT( record_id ) as post_count FROM `wp_my_posts`
   WHERE my_ID =’15′” );
 * foreach($checkpost as $checkposts)
    {echo $checkposts->post_count; echo $checkposts-
   >mypost; } }

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