Sorting tables - clicking on field names

[knayam]

This functionality appears so common to all websites that
I naively assumed it had an obvious solution. Now I am to my wits end solving it. So I ask for help.....

Question --

There is a table with field names

First Name     Last Name     Company Name

Now I need to show the table sorted by First Name if the user clicks 'First Name' and so on for other fields. How do i do it?

I suppose i need to use PHP_SELF and pass the ORDER BY variable ! Can I do it without using the <form> tag?

Thanks ya all..

Mayank

[bastien]

<a href="$PHP_SELF?sort=Fname">First name</a>

and in the page
1. decide on default method (fname, date etc)
2. check for the existance of sort
3. create the query based on sort or default
4. run query and show results.

hth