How to select data order

kevgray

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

kthorngren

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

kevgray

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