interactivel sorting mysql tables

[Roger Lord]

From a html file I have something like this:

<a href="showtable .php?table=clie nts&col=lastnam e"><b>Mysql
Table</b></a>

This is a general mysql table viewer for a database.

showtable.php displays the table in a browser fine. It uses the
'clients' table and sorts it by 'lastname' passed in on the command
line. The sorting is done by "order by". So far, so good.

Now I'd like to have some buttons at the top of each column to cause
the table to redisplay sorted by the column that the user clicks on.
Is this possible?
Basically I need to re-call showtable.php with different valuse for
the col parameter.

Does anyone know how I can allow the user to interactives sort columns
this way? Like a window listview control.

thanks,
Roger

[nice.guy.nige]

Re: interactivel sorting mysql tables

While the city slept, Roger Lord (rlord17889@yah oo.com) feverishly typed...
[color=blue]
> From a html file I have something like this:
>
> <a href="showtable .php?table=clie nts&col=lastnam e"><b>Mysql
> Table</b></a>
>
> This is a general mysql table viewer for a database.
>
> showtable.php displays the table in a browser fine. It uses the
> 'clients' table and sorts it by 'lastname' passed in on the command
> line. The sorting is done by "order by". So far, so good.
>
> Now I'd like to have some buttons at the top of each column to cause
> the table to redisplay sorted by the column that the user clicks on.
> Is this possible?
> Basically I need to re-call showtable.php with different valuse for
> the col parameter.
>
> Does anyone know how I can allow the user to interactives sort columns
> this way? Like a window listview control.
>
> thanks,
> Roger[/color]

Wouldn't the following work?

<a href="showtable .php?table=clie nts&col=firstna me">Sort by first
name</a>
<a href="showtable .php?table=clie nts&col=lastnam e">Sort by last name</a>
<a href="showtable .php?table=clie nts&col=age">So rt by age</a>
<a href="showtable .php?table=clie nts&col=haircol our">Sort by hair
colour</a>

SELECT * FROM $table ORDER BY $col

Cheers,
Nige

--
Nigel Moss

http://www.nigenet.org.uk

Mail address not valid. nigel@DOG.nigen et.org.uk, take the DOG. out!
In the land of the blind, the one-eyed man is very, very busy!