Hello

I wonder if someone can help or point me in the right direction. Basically, I want to create a table (database) similiar in style with this http://www.broadbandchoices.co.uk/calculator.asp which can be sorted by the user by selecting the appropriate column they want to sort by ie. cheapest price first. The broadband is irrelevant in this, I just need to know how I can create a table which can sort like that or if there is a script available that does this for you. Many thanks for your time.

Warm regards

You cannot sort the table itself, but you can sort the result of a SELECT query with the ORDER BY option.

SELECT * FROM table ORDER BY field

Have a link saying something like 'Sort by Price'

which goes to the page 'yourpage.aspx?sort=price'

then in your page have your script extract the querystring and sort the table. For example, C#:

SELECT * FROM table ORDER BY "+Request["sort"]+"