Dynamically Sort in a table

Thanks...

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

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

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

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 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