PDA

View Full Version : Table Sorting... how???



Cixso
20-02-2009, 02:54 PM
I want a table that has a search feature on it so you search for data in the table and where you can sort each column by ascending/descending or by numeric.

How do I do it?

Joe!
20-02-2009, 04:42 PM
A table within a MySQL database? A table within your website that uses javascript to change the ordering? Be a bit more descriptive.

Cixso
20-02-2009, 06:01 PM
A table within a MySQL database? A table within your website that uses javascript to change the ordering? Be a bit more descriptive.

I don't have a mysql database for the table or a JavaScript although I will be keen on using the easiest method if somebody could show me a tutorial?

I just want a table that I can sort.

Joe!
20-02-2009, 07:56 PM
Where will you be pulling the data from?

Cixso
20-02-2009, 08:01 PM
Where will you be pulling the data from?

The data is static on a webpage. I want to transfer this to what ever method is best so visitors can sort the data via ascending descending.

It's a price comparison table.

Dentafrice
21-02-2009, 02:25 PM
Make a MySQL database with the fields in it, then pull the data from MySQL based on the selection.

In your query:
ORDER BY `id` ASC
ORDER BY `id` DESC

ORDER BY `price` ASC
ORDER BY `price` DESC

Like that.

Cixso
21-02-2009, 02:50 PM
Make a MySQL database with the fields in it, then pull the data from MySQL based on the selection.

In your query:
ORDER BY `id` ASC
ORDER BY `id` DESC

ORDER BY `price` ASC
ORDER BY `price` DESC

Like that.

Ahh I see... thank you.

Want to hide these adverts? Register an account for free!