Dynamically Sort in a table

[Jeney]

Using DW MX2004 and MSAccess. I have a table that pulls information from my database - it has column headers. I would like to make the headers (when selected) sort the table. Example: My table has Model and Manufacturer along with other things like item description etc. I want the user to be able to click the 'Model' header and the table will reindex based on Model. Same with Manufacturer etc. What is the easiest way to accomplish this?

[Newsgroup_User]

Jeney wrote:

> Using DW MX2004 and MSAccess. I have a table that pulls information from my
> database - it has column headers. I would like to make the headers (when
> selected) sort the table. Example: My table has Model and Manufacturer along
> with other things like item description etc. I want the user to be able to
> click the 'Model' header and the table will reindex based on Model. Same with
> Manufacturer etc. What is the easiest way to accomplish this?
>
something like this?
http://www.mickweb.com/football/rhinos/2006/profiles2006.php
Mick

[Guest]

Hey Jeney

Try this have not tested it yet.

$query="select * from table";
if(isset($_GET["orderby"])){
$query.=" order by ".$_GET["orderby"];
}

Cheers
West

[Jeney]

Yes Mick - exactly like that - I can't use PHP...

[Guest · Accepted solution]

Sorry I have done it again, I keep forgetting to read the post as well.

Try these:
http://www.webthang.co.uk/tuts/tuts_dmx/dynasort/sort1/films.asp?Submit=Z-A&order=genere+desc
This is a tutorial:
http://www.webthang.co.uk/tuts/tuts_dmx/dynasort/dynasort.asp

Cheers
West

[Newsgroup_User]

Jeney wrote:

> Yes Mick - exactly like that - I can't use PHP...

Can you post a URL?
The script is a little complicated, it needs to know the nature of what
it is sorting. I'll show you what to do.
Mick

[Jeney]

Thanks...

http://www.mri-sales.com/AllInventory.asp

[Guest]

Hi Jeney

It seems you need someone like Mike to sort out these problems as doing it yourself isn't working.

Cheers
West