Sorting

[Anon]

Hello,

Is there a way to let the user sort the table? I've got a table (ODBC connection) wich is sorted on field1. When the users click on the header from field2 I want it to sort on field2 etc.
Is this possible?

[mwilson]

Of course this is possible, let's say we had the link for sorting by field2 something like;

<a href="myscript.php?sort=field2">Sort by field2</a>

then within myscript.php you would simply have to check the variable $sort against the column names and sort by the specified column, if the column doesn't exist then simply reset it back to field1 (or whatever).

HTH

Matt

[Anon]

Thanks for your help but I can't get it done. This is probably due to my little experience with PHP. I just started learning PHP. Maybe you could give me some help through a little example.