Output with assending and desending?

[wooowooo]

Hi

 

Does anyone know if its possible to use php to display a table from mysql database with links so its user can change weather its sorted assendingly or desendingly using different column headings?

 

IE,

 

Column headings are A,B,C

 

I want to know if I could have it so the user sorts the table assending of descending as they please using any of the three headings to sort and if you can how is it done?

 

Many thanks

[teng84]

you have to use get variables eg..

 

sample u have url like this

page.php?sort=asc&field = name

if (isset($_GET['sort']) && isset($_GET['name']) ){

 

$select ='select * from yourtable order by'.$_GET['name']. $_GET['sort'];

}

 

note you still need to filter input...

 

 

[wooowooo]

Not following 100%

 

Any chance of abit more info?

[teng84]

http://www.w3schools.com/php/php_get.asp  read...

 

do you know how to use those global variables ?

[wooowooo]

Yeah I follow that but I dont see how it ties in with the table and assending of dessending

[woocha]

if your page is www.example.com/test.php

your comlun header, column A should be a hyperlink to www.example.com/test.php?sort=inset_mysql_filed_here

[DyslexicDog]

Yeah I follow that but I dont see how it ties in with the table and assending of dessending

 

In the example php is not sorting the information mysql is. The example changes the query sent to the database, returning the information in the desired order.

[PHP_PhREEEk]

I wrote a script for a user here that sorts by any column. The post is here:

 

http://www.phpfreaks.com/forums/index.php/topic,166794.msg735733.html#msg735733

 

There are two scripts. The sorting portion is located in customers.php

 

Everything you need to sort the table is easily laid out. It's a very small script.

 

PhREEEk

[revraz]

They way I create my pages is that I code the Field Names as links and when you click on it once it sorts ASC, then if you click on it a 2nd time, it sorts DESC