How to query 'additional 10' results from database in a React + Express server

Question

I have a frontend built in React and a backend built in Express. I query my API from the frontend, and get back 10 results. This is the query in the backend

SELECT * FROM games LIMIT 10

Say I wan to implement infinite scroll. I'd like to query 10 more results, but not the same as before. What technique could I use, both/either on frontend or backend code?

Could I pass perhaps a number to my api string which gets incremented every time, e.g. 1st 10, then 20, then 30, to show the number of results, but how can I do that in a SQL query?

Gyanendro Kh · Accepted Answer · 2021-06-08 15:51:16Z

1

SELECT * FROM games LIMIT 10 OFFSET 10

Here you will get item 11 to 20. Now you can change the offset value to whatever you want.

answered Jun 8, 2021 at 15:51

Gyanendro Kh

4055 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to query 'additional 10' results from database in a React + Express server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related