Customizing SMF > SMF Coding Discussion

SQL question

(1/3) > >>

Study Force:
Hi everyone,

Say I have a table with many rows, and I wanted to limit the query between rows 10,000 and 20,000 or 300 to 400, how would I change the
--- Code: ---LIMIT
--- End code ---
part to reflect that?

vbgamer45:
LIMIT 10000, 20000

albertlast:
The fastest and litte complex way is to use Keyset Pagination:
https://www.citusdata.com/blog/2016/03/30/five-ways-to-paginate/

Study Force:
Thank you both.

Study Force:

--- Quote from: vbgamer45 on June 11, 2018, 01:03:51 PM ---LIMIT 10000, 20000


--- End quote ---

Are you sure this will give me 10000 rows? I.e. 20,000 - 10,000 = 10,000?

Please when I write $count = mysql_num_rows($request); it gives me 20,000. I need the difference

Navigation

[0] Message Index

[#] Next page

Go to full version