PHP/MySQL Multiple Sort

[southofsomewhere]

 

Long story short..

 

I'm trying to devise a way to be able to collapse/expand multiple tables, and be able to sort them when they're expanded.

 

Each table is a different row of a MySQL query, where the first table that will always be displayed no matter what displays information about the organization.. and the second query deals with looping through that organizations records and displaying the members associated with it.

 

These tables are in nested for-loops.. where the first for prints off information about the organization (which will always be shown), and the 2nd displays the actual members of the organization (this is the part I wish to collapse/expand and sort via name, admin, students).

 

Main issue I'm having is to how to go about managing all of the possibilities.. you could have multiple organizations expanded and sorted all in different ways, and trying to use a $_GET in some way shape or form would probably produce a very complex and long string in the end.

 

I've been looking into some JavaScript possibilities, but that route could get tricky as well linking 3 lists to each other and importing an sql query into them.. but its food for thought.

 

If any further explanation is required feel free to inquire.

 

Thanks

[DyslexicDog]

I think client side javascript is going to be the best way to accomplish your goal. What you are asking can be completed with $_GET but like you said it may get complex.