Lee, looks like you need to look at OFFSET in MySQL, there is a pretty good explantation here.
You can just multiply the offset by the page number -1 so page 2 will only offset 10 instead of 20 and so on.
Related Posts:
- What is the correct way to use WordPress functions outside WordPress files?
- WP-CLI – Selecting PHP version
- Hide php Notices in Dashboard
- Place page title in header?
- Shortcode to insert
- Gutenberg Blocks doesn’t render correctly when using do_blocks
- WordPress new user / forgot password emails are broken
- How to get year, month and hour in WordPress?
- Calling a method from functions.php on a click of a button
- Specified file failed upload test. wp_upload_handle
- Want to separate sections of posts. Can you restart loop?
- How to change featured content to a different tag in WordPress Twenty Fourteen?
- Using Echo in ShortCode – Stuck
- How do I create comment-reply-button using element not
- Two posts in same div – WP loop
- Compare two meta key values against each other inside the get_posts array?
- Removing WordPress profile fields from non-admins
- WordPress menu deletes when trying to add a hook
- Issue with foreach on duplicate meta_key’s
- Why am I getting ERR_NAME_NOT_RESOLVED when I add a site to my multisite installation? [closed]
- How to display custom field on homepage
- Show custom field if it exists, and show different elements if it doesn’t
- Making Quote Plugin more efficient
- Different database query in function.php using mysqli
- Create shortcodes within foreach loop (using array)
- Programmatically add and remove woocommerce product category
- Get image’s size name from it’s dimension
- add element with add_action to posts from a specific category ID
- developing a wordpress plugin, have a few PHP Woocommerce related coding questions
- How to pick the default selected value in wordpress dropdown?
- Using WP-API and SSE not authenticating user ID
- Output ACF repeater on frontend user’s profile page (created with Ultimate Member) [closed]
- How to target grandchild of post_parent using wp_list_pages
- remove post that has no content
- How to show only subcategories in parent category not parent category?
- Can you use a WordPress front-end only and have rest of pages as pure PHP
- Security: blocking direct access of php files
- Get post id within comments loop
- Woocommerce change prices for a certain country [closed]
- Adding PHP in the menu
- WordPress Environment: Dynamic Page using shortcode – how to change the page name for sharing
- Reason to add a name of the theme like (‘menu-1’ => __( ‘Primary’, ‘twentynineteen’ ),) in PHP?
- persist a variable set in header.php all the way down to footer.php
- Where are the src and srcset sizes coming from?
- wp_remote_post empty $_POST
- How can I spin up a new website for a registered user automatically?
- What is the alternative code to if (isset ($_POST) && !empty ($_POST) to avoid warnings?
- Remove item in Checkout
- How to show every second user different types of banners?
- Woocommerce – get_items() returns empty array
- echo esc_url( get_permalink($post->ID) + complete the ID’s url
- Need help with pagination
- get_comments_number() returns 0
- How to add a rewrite endpoint to unattached media?
- Adding Additional Variables on Menus Page
- Querying for specific tags
- Why the dynamic_sidebar() call is putted into an ul tag?
- Accessing an API with jQuery and AJAX
- Timber right sidebar in WordPress theme
- Get main parent category for post (WordPress/Advanced Custom Fields)
- How to run complex query using PHP
- Store ajax data in PHP variable
- comment_post (if comment is approved OR $comment_approved === 1) not working?
- How to remove Login from in my account page
- Configure WordPress to Use Responsive Image Rendering
- Creating multiple tables with Plugin
- How can i create a function tag in my plugin
- Why the responseText containing those two arrow signs at the beginning
- Call jQuery function from PHP?
- How to Get Linked Elements for a specific ml_source_elementid
- Meta Box clears saved field content
- Woocommerce remove menu item on myaccount dashboard
- Hook into all password resets in WordPress and get password before hashing?
- WordPress select query issue
- Metabox – Displaying the Value of a Metabox
- woocommerce plugin bugs
- Getting most popular posts based on Facebook comments count
- WordPress get_post_meta issue
- Woocommerce Price Text
- Best way to define a database with product codes and back-end support?
- Is there a way to randomize and connect a background and header image?
- Post Thumbnail on Single (if elseif else)
- Display pages from specific page template
- If Elseif Query
- Querying multiple meta_keys in WordPress SQL query
- dynamically filter by category via sub-menu
- 3 domains, 1 wordpress install, redirecting and changing domains on live site
- Sidebar doesnt get updated?
- Edit the Publish Widget Options
- How can I print out a single stylesheet or javascript link?
- WordPress post pagination on custom template not working
- get_option(‘admin_email’) not working in wordpress when using ajax call
- wordpress featured image
- Generating a number based on post ID
- How do I update product shipping using PHP in WooCommerce?
- How can I edit the WooCommerce Mini DropDown Cart to read as follows
- Disable Typed Parameters for JavaScript in PhpStorm? [closed]
- Properly process a custom WP REST API request (Authenticate, Authorize + Validate)?
- Losing Session ID and sessionStorage when navigating to other domains on Multisite
- WordPress critical error after trying to update to 6.2 – Fatal error: Allowed memory size of 268435456 bytes exhausted