Disable autosorting

bernte

Hi guys... short question..

i get my query this way

[code]$query = "SELECT userid,username,fullname FROM user ORDER BY username ASC";[/code]

but in the table its ordered by userid.. but i want it raw out of my query into table but must be sortable by clicking on thead..

i don't don't wont to create for every table a new jquery (i have many tables with different order functions)
this is my table-code:

[code]
$('#normal-table').dataTable( {
"bJQueryUI": true,
"bPaginate": false
});
[/code]


with this code i recieve the sorting-methode from my query.. but i can't click sort on thead:

[code]
$('#normal-table').dataTable( {
"bJQueryUI": true,
"bPaginate": false,
"bSort": false,
});
[/code]

is there a way to do this?

bernte

[code]
$('#normal-table').dataTable( {
"bJQueryUI": true,
"bPaginate": false,
"aaSorting": []
});
[/code]

did it :D