Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Topic started by: Stanyy on October 27, 2018, 05:05:01 AM

Title: Paginate Query Results
Post by: Stanyy on October 27, 2018, 05:05:01 AM
Hi,

I have written queries using $smcFunc['db_query']. How do I paginate these results?

Regards
Title: Re: Paginate Query Results
Post by: Arantor on October 27, 2018, 06:08:09 AM
You use a LIMIT clause in the SQL itself and pass in how many items to skip and how many items to retrieve just like the rest of SMF does.