SSP class server-side ORDER BY

SSP class server-side ORDER BY

dadko123456789dadko123456789 Posts: 8Questions: 1Answers: 0

Hello,

I use that code https://datatables.net/examples/server_side/simple.html and I need to add ORDER BY to query but on the server-side, in PHP file, not in a script.
How can I do that?

Thanks

Answers

  • allanallan Posts: 61,716Questions: 1Answers: 10,108 Site admin

    The order is defined by the order requested from the client (i.e. the browser). It is sent as part of the order property to the server so it can be processed there. If you only want one column to be orderable, use columns.orderable to disable ordering on columns you don't want to be orderable.

    Allan

  • dadko123456789dadko123456789 Posts: 8Questions: 1Answers: 0

    I need more columns to order, and want to use ORDER BY function in the server-side script, but don't know how to edit the query.

  • dadko123456789dadko123456789 Posts: 8Questions: 1Answers: 0

    Any advice how to do it?

    thanks!

This discussion has been closed.