jeudi 20 août 2020

mysql select random 10 posts with 10 pages from database and after refreshing it , Numbers of the current page become different

I just want to know whether I can make it or not. Thank you for helping me in advance.

I have 100 posts. There are 10 pages. I want to display 10 random posts with each pages.

If I refresh the page, numbers should be changed in the page . If I go to the previous page, it should not be same with the current page.

For example 
First Page 1,2,3,4,5,6,7,8,10,59
Second Page 9,11,12,13,14,15,16,17,18,19
.
.
.
Total 1 - 100 posts, not duplicated numbers with each Page

After Refreshing the page( I know if I go to the next page, it is also refreshing the page , but that time it should not be different)
First Page 1,3,5,6,7,8,9,10,91,100
Second Page 25,37,11,20,33,40,55,56,99,19
.
.
.

I want to select this query from database and number of posts are over 100000. Can I make it?

I just wonder whether I can make it or not. If it's not possible, it is also fine. Thank you.




Aucun commentaire:

Enregistrer un commentaire