how to design selectable table

well, I need some help for designing a table that's showing some DB results and it should be able to sort/select some of the values. (there's no problem in getting the data once I know which ones)

so, the (html) table structure is like (the columns to be sortable marked in bold)
where "status", "seller" and "category" are a distinct set of values. and by sorting I want to show only the selected entries thereof (which can be done via <select> dropdown)

what I want is a good idea how to sort the "date" and "price" (both would be a range type) columns (currently I'm using a separate form for all values) and how to display it in a nice way.

one more thing, it would be nice if I could combine the queries (like getting all items seller A has in category M)

thanks in advance, Dormi

re: how to design selectable table

as soon as I see you want a sort a table I immediately think of jquery and the table sorter plugin. Its marvelous. You might have to work the other features you want into it, but I think thats a good start.

http://tablesorter.com/docs/#Demo

re: how to design selectable table

looks good but In don’t have a static table here. (the sorting needs to be done on the DB entries)