RE: [PHP-DB] Ascending and Descending records

include a link(s) at the top of the column(asc/desc) and pass that value back to the server. then use that value to sort the column link = <a href='<?=$_SERVER['PHP_SELF']?>?col=colname&sort=asc'>Asc</a> then on the server $col = $_REQUEST['col']; $sort= $_REQUEST['sort']; sql= "select * from tableName [where] order by $col $sort"; bastien

From: "Aaron Todd" <aaloki88@hotmail.com> To: php-db@lists.php.net Subject: [PHP-DB] Ascending and Descending records Date: Tue, 5 Oct 2004 12:35:32 -0400 I have a page that shows data from a MySQL database in a table form. I'd like to give this page the ability to be able to sort a column when the user clicks on the header cell that contains the name of the column. I'd also like the ability to do both Ascending and Descending with the same link much like just using Excel. Does anyone know of a good source for accomplishing this? Thanks, Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ Designer Mail isn't just fun to send, it's fun to receive. Use special stationery, fonts and colors. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*.