if the order is not to be based on any of the existing columns, there really is not another way except to create a new column specifically for sorting the results.
this thread:
showthread.php?t=9353
has a tutorial for using ajax to accomplish setting the sort order.