I'm making a website with my movies and am trying to make the pagination by last id, date, views, and rating.
I can easily make the pagination by last id just by querying the database
ORDER BY movie_id DESC
movie_id movie_title movie_subtitle movie_desc movie_data movie_views movie_rating
simple query will be the best and easy solution write a query with required where clause and then just appy the limit and offset values.