Simple Sorting Function for a Dynamic Table

[TheRapidGroup]

Hello everyone, I was wondering if their was a way in dreamweaver to allow
your site users to sort the data displayed in a dynamic table on your site??
Preferably in a drop down menu but any help anyone may be able to give would be
most appreciated!

[stevenlmas]

Create your SQL on the fly, say via a querystring so you have something like:
[url]www.site.com/mytablepage.asp?sort=lastname[/url] find where the SQL is generated on
your table page, Look for something like: ssql = 'SELECT * FROM customers'
after this line add something like: if request.querystring('sort') <> '' then
'there's something to sort by ssql =ssql &amp; ' ORDER BY ' &amp;
request.querystring('sort') then you can add links at the column heads or in a
drop down that look something like: <a
href='mytablepage.asp?sort=lastname'>Last Name</a> <a
href='mytablepage.asp?sort=address'>Address</a> <a
href='mytablepage.asp?sort=city'>City</a> the page links to itself, but each
link re-sorts the recordset. Check out [url]http://www.riverfrontmarine.com/[/url] and
look at the new and used boats. Look at the URL in the status bar when you
mouse over the column heads and you'll get an idea of what I did. This example
is ASP but you could do the same with PHP or JSP. Best of luck, Steve
Vaporloop: Technology Solutions for Small Businesses

[stevenlmas]

the code I wrote to show you how to make the sort links where converted to
actual links. here they are w/o the tags so they show up. a
href='mytablepage.asp?sort=lastname' LAST NAME /a a
href='mytablepage.asp?sort=city' CITY /a a href='mytaplepage.asp?sort=state
STATE /a

[TheRapidGroup]

Thanks for taking the time to help me out. I am going to try it out right now.