How can i limit the number of posts to the most recent 6 in my query?

After i posted the question, i was told the staging site which i was working on, and the production site’s code was out of sync.

The answer ended up being simple:
'posts_per_page' => 8, (which was actually working but was out of sync with repos / server)
was actually set to 'posts_per_page' => -1, which i changed to 'posts_per_page' => 6, and that did it!

And for pulling the most recent, i didn’t realize it does by default, which i found that answer here.

Related Posts:

  1. the_date() not working
  2. Delete post revisions on post publish
  3. How to sort results from a custom database table
  4. WP database error for comments_popup_link()
  5. Why is variable not working on custom sql query using wpdb?
  6. Create WP_Query to search for posts by their categories or their parent/child categories
  7. mysql query from wordpress page using custom table
  8. Long running queries
  9. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  10. WordPress SQL injection
  11. mySQL queries are executed twice on wordpress website
  12. WordPress Custom Query: Combining Two Functions
  13. SQL error with custom query
  14. Query doesn’t display text data with apostrophes
  15. How to do a MySql query in WordPress?
  16. How can I display a query in a page?
  17. Include a custom field in mysql query
  18. Query Concatenation
  19. wp query foreach deleting record returning only first or last item
  20. Refresh table data with Ajax
  21. Two queries for a WP_User_Query search work perfectly apart, but not together
  22. Trying to get a PHP variable defined in a custom post into a javascript file. Null value. Using wp_localize_script
  23. database sent to a JSON file
  24. Limit 1 global comment per minute
  25. inserting a post from an extern php file but post content doesn’t show on wp site
  26. Query if audio attachment AND/OR custom field
  27. Database query works fine outside WordPress
  28. $wpdb->wp_users returning empty value for
  29. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  30. $wpdb->insert() does not Insert record in a table
  31. Using custom tables for old posts
  32. register_taxonomy() take much queries
  33. Help with a $wpdb MySQL Query
  34. Not connecting to database in file with multiple MySQL connections
  35. Which is the correct way to conditionally enqueue a CSS file?
  36. Way to bulk make all my tags lowercase?
  37. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  38. How i can obtain all the post meta for a specific post as an array?
  39. multiple where condition in result query
  40. Odd / Even posts add class minus first post
  41. Grouping posts by a custom meta value
  42. unable to use ‘new WP_Query’ in AJAX call
  43. Multiple meta_key in one global $wpdb;
  44. Custom array from a query only write the last row of the query
  45. WordPress member notification
  46. Parse error: syntax error, unexpected ‘}’ on get_the_author_meta [closed]
  47. Can’t Query Custom Table Using $wpdb Method
  48. Defined WordPress Memory Limit to Unlimited
  49. Moving wordpress site from localhost to live server using GoDaddy cPanel
  50. How does WP work in conjunction with a web server?
  51. WordPress Block developer from exporting Database via PHP
  52. How to list commenters and days since last commented
  53. How to add div blocks after certain set of post
  54. $wpdb returns duplicate posts
  55. How to overwrite orderby with add_query_var
  56. Can’t update multiple rows with $wpdb query
  57. Update postmeta after theme switch
  58. How to solve Woocommerce Memory Limit
  59. Mixing variables into an array when inserting values
  60. Location of core code for database connection and get_header
  61. wpdb prepare insert table doesn’t work
  62. Should I use WordPress to skin a database website?
  63. php include not working in custom page
  64. How do I display offsite database info on my wordpress site?
  65. Creating Database Table vs. Adding MetaData to Post & User
  66. Make a database query using WordPress
  67. Force Users To Relogin
  68. working with term_relationships table
  69. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  70. WordPress Custom SQL Table with UserID Filter for results
  71. WordPress query undefined offset in loop
  72. Most commented posts by time period (last 12h, last 24h and etc)
  73. WordPress hit memory limit but not from the server
  74. Can I make get_users() query global?
  75. Use $wpdb or other PHP script method to find/replace in WP database
  76. email alert for product availability
  77. How can I add a new row in a separate database when someone registers via WordPress?
  78. Issue with fetching mysql data and displaying results via shortcode in webpage
  79. Issue with custom loop in Archive page
  80. How to display SQL query that ran in WC_Order_Query?
  81. Basic wpdb update question
  82. Custom Post type slider with thumbnail navigation
  83. Hide posts if user is added to it WP_query
  84. I can’t update my data through $wpdb
  85. A $_POST should occur when submit form but is not?
  86. Parse error: syntax error, unexpected ‘}’ [closed]
  87. Custom route and query
  88. Output: “Array”
  89. Shortcode to pull posts
  90. How to unserialize data from MySQL
  91. How to use mysql LIKE with wpdb?
  92. PHP -> SQL Query with Summing
  93. How to hide posts of a specific custom category in WordPress?
  94. Pull MySQL data from multiple tables and merge into 1 PHP array
  95. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  96. WordPress WP_Query without query GET parameters
  97. How do I prepare strings for insertions as values into a MySQL table?
  98. Known Issues in WordPress When Upgrading PHP to ver 7
  99. Using CFDB7 vs Custom MySQL Database [closed]
  100. Why is my max_upload_filesize being limited to 2M? [duplicate]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)