How to select data order

How to select data order

kevgraykevgray Posts: 9Questions: 5Answers: 0

Hi, no matter how I do a select on my table I can't get it to read using the 'order by' in the select statement, it just gets ignored.
Here is my table structure -
If I do an 'order by Rank22' the data is displayed in 'Driver' order.
I'm puzzled, can anybody help please ?
Thanks, Kev.
slotcarsatleicester.co.uk/w23/nr.php

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 19,864Questions: 26Answers: 4,685
    Answer ✓

    By default Datatables will order by the first column. Sounds like you want the order based on what is sent from the server. Use order to tell Datatables to not initially order the table with "order": [].

    Kevin

  • kevgraykevgray Posts: 9Questions: 5Answers: 0

    Sorry about the duplicate, this solved my question, thank you kthorngren.

Sign In or Register to comment.