PDA

View Full Version : Re-sort table by clicking column names


gschimek
09-26-2011, 01:56 AM
I'm setting up a new site in Dreamweaver 5.5. I've created a database connection and a recordset, and used them to create a Dynamic Table. My table columns are Name, City, and Job. My recordset sorts the data by Name, but I'd like to know if there's a way within the confines of Dreamweaver to be able to resort the data by City or Job, possibly by clicking on the column headers, or I'd be fine with setting up a form to submit and check for a variable.

I've done this previously by writing the code myself, but if I start using some of those techniques, it breaks my recordsets.

Any suggestions? With as many dynamic functions as there are in Dreamweaver, I would think this would be possible.

Thanks in advance!

edbr
09-26-2011, 04:51 AM
you could use a variable example $order , your select query cvould be select * for table order by $order then to can pass the variable as a post or Get value

davidj
09-30-2011, 02:40 PM
Try this...

http://tablesorter.com/docs/