Title: define83's Replies | WordPress.org

---

# define83

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

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

 Search replies:

## Forum Replies Created

Viewing 1 replies (of 1 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [How to display the “number of posts in the last 24 hours”?](https://wordpress.org/support/topic/how-to-display-the-number-of-posts-in-the-last-24-hours/)
 *  [define83](https://wordpress.org/support/users/define83/)
 * (@define83)
 * [17 years, 9 months ago](https://wordpress.org/support/topic/how-to-display-the-number-of-posts-in-the-last-24-hours/#post-812752)
 * Hi steve, you can try something like
 *     ```
       $allDay = date('Y-m-d H:i:s', strtotime('-1 day'));
   
       $numpost = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND post_date > '$allDay'"); echo $numpost;
       ```
   

Viewing 1 replies (of 1 total)