This content has been marked as final. Show 3 replies
Do you use multiple recordsets per page
No, but i think you have to add more extra field for the order as you required, then grasp it by request it from the recordset.
Developer-Online Creator and programmer
ADDT Dynamic lists already have sorting features built into the list.
Are you using a Dynamic list?
I've seen websites that change the sorting order of a repeating region based on a URL parameter (ex. thispage.php?sort=state). I cannot for the life of me figure out how to do this with ADDT
You´ll basically need to turn the recordset´s static ORDER BY statement into a dynamic one, means something like:
"SELECT * FROM tablename WHERE... ORDER BY ".$_GET['sort'].""
This is of course a very basic example which assumes *that* thispage.php will always be referenced from e.g. another page that´s passing the URL parameter "sort" -- but in case thispage.php is supposed to additionally get loaded in a sort of stand-alone mode, you´ll need to implement a much more advanced PHP logic by basically defining an if/else condition which checks if the URL parameter "sort" is set or not, and turning the whole "ORDER BY whatever_condition" statement into a dynamic PHP component.
Or is it simply not possible with ADDT?
It requires manual PHP coding, and such a modified recordset will usually no longer be visible in DW´s server behaviours list
Adobe Community Expert, Dreamweaver