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

Thread Tools Display Modes
Old 09-26-2011, 12:56 AM   #1
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's Avatar
Join Date: Aug 2005
Location: Bali
Posts: 11,203

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's Avatar
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256

Try this...

Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote

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 04:11 AM.

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