如何对包含jQuery Datatables中数据库值以外的服务器端生成值的列进行排序。

I am using jQuery Datatables for one of my page to display data.I am using server-side scripting to display datatables.

In my html I have 8 columns.5 columns for fetched values and other 3 contains some mathematics calculations with php functions that I am returning in the server side script.Those are not depends on database fields.

I changed $output[] to add my generated values and all are work fine.

What my problem is I need to sort columns that have generated values.But this is not possible because datatables mysql ordering statement makes error because these columns are not in actual mysql table.

So how would I able to do sorting above fields? Do we have any sorting that I can do for those columns without interfering mysql ordering clause(may be sort in client side).

Thanks.