table sort using jquery datatable?

table sort using jquery datatable?

Hey gurus,

Please forgive me if this question appears silly.

I have been looking all over the place including at this forum for either ajax or jquery table sorter and so far, everything I have seen sorts only the current page.

I have already also seen some references to jquery datatable but I have not seen a specific instance of datable being used to sort database.

Do you gurus know where I might find an example to perhaps model after?

My app is ready but only hold up is the sorting bit.

Thanks as always for your assistance.