How to sort multiple columns in a mysql table to obtain the first or next column of a specified value?

Mysql tables are sorted by multiple columns to obtain the first or next entry of a specified value. how can we make it simple? mysql, table name: tblsale, there are two fields, date and index, to determine a sales order (n orders in a day are identified by index). the records in the table are not necessarily discharged in order, because there is a possibility of subsequent addition. How to sort multiple columns in a mysql table to obtain the first or next column of a specified value?
The table name tblsale is a mysql database for purchase, sales, and inventory. There are two fields: date and index to determine a sales order (n orders exist in one day, which are differentiated by index ), the records in the table are not necessarily discharged in order, because there is a possibility of additional charges.
Simply sort the records in the table. you can use order by date and index to sort the records (in ascending or descending order as needed ).
Now the front end uploads a date and an index. based on the specific date and index, we can find the previous or next order. In PHP, how can we make it simple? Share: More