Sort a Repeat Region, PHP, how-to?

[slakker]

Hi all.. I have a table with 3 columns and many rows..
Very top row has the column headings, then I skip a row to give it some space, and then I have the rest of the rows showing data from mysql DB.
I have this setup as a repeat region in DWMX..

I would really like to know if I can sort my whole repeat region by clicking on any one of my 3 column headings..
like.. sort by Name, Title, Email, etc..

This is a commercial extension that someone make, which does just that, and which is a perfect example of what I have.. and want..

I've spent a bunch of money on stupid little things recently and would rather not do it again.. hehe

So, if anyone has any ideas, I would appreciate it.

Thanks in advance!

 

[slakker]

Sorry, this is the page demo:

http://www.basic-ultradev.com/exthelp/sortrepeatregion/sortnav.asp

 

[deecee]

its all in your select statement you need to order by

select *
from table
where price = $variable ORDER BY price

<Signature>
Sometimes the Answer You Are LOOKING for can be FOUND BY SEARCHING THE FAQ'S @&%$*#!!!
</Signature>

 

[Cheech]

just use the column headings to post back to the same page with a querystring attached then do your select based on the variable

example 2 column headings one with a link to mypage.asp?sort=column1 the other to mypage.asp?sort=column2

top of your mypage.asp

strSort = request.querystring("sort")

and your select = 

"SELECT * FROM TABLE ...... ORDER BY " + strSort

Cheech

[Peace][Pipe]