logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 09-26-2011, 12:56 AM   #1
gschimek
 
Join Date: Sep 2011
Posts: 1
Default Re-sort table by clicking column names

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!
gschimek is offline   Reply With Quote
Old 09-26-2011, 03:51 AM   #2
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,164
Default

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
__________________
If you're happy and you know it shake your meds!
different style links examples

Flight / Hotel search
Free script download
Bali Villas
edbr is offline   Reply With Quote
Old 09-30-2011, 01:40 PM   #3
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

Try this...

http://tablesorter.com/docs/
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:27 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com