wooowooo Posted December 21, 2007 Share Posted December 21, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/ Share on other sites More sharing options...
teng84 Posted December 21, 2007 Share Posted December 21, 2007 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... Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420121 Share on other sites More sharing options...
wooowooo Posted December 21, 2007 Author Share Posted December 21, 2007 Not following 100% Any chance of abit more info? Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420126 Share on other sites More sharing options...
teng84 Posted December 21, 2007 Share Posted December 21, 2007 http://www.w3schools.com/php/php_get.asp read... do you know how to use those global variables ? Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420133 Share on other sites More sharing options...
wooowooo Posted December 21, 2007 Author Share Posted December 21, 2007 Yeah I follow that but I dont see how it ties in with the table and assending of dessending Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420136 Share on other sites More sharing options...
woocha Posted December 21, 2007 Share Posted December 21, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420141 Share on other sites More sharing options...
DyslexicDog Posted December 21, 2007 Share Posted December 21, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420192 Share on other sites More sharing options...
PHP_PhREEEk Posted December 21, 2007 Share Posted December 21, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420197 Share on other sites More sharing options...
revraz Posted December 21, 2007 Share Posted December 21, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/82614-output-with-assending-and-desending/#findComment-420206 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.